Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-access > #13773

Re: FTP a file(s) using MS Access

Newsgroups comp.databases.ms-access
Date 2019-09-05 06:11 -0700
References <3efumeh5gvsg3623o260u00uaeode4r4vo@4ax.com>
Message-ID <2de56cd8-0618-4ab9-b774-e165acfc1a5b@googlegroups.com> (permalink)
Subject Re: FTP a file(s) using MS Access
From samxjones2@gmail.com

Show all headers | View raw

On Tuesday, September 3, 2019 at 10:31:49 PM UTC-5, PW wrote:
> Hi,
> 
> Has anyone successfully done this?
> 
> I found a link with a download sample, nice form and docs, but it does
> not work because two files that are needed to run it are not in the
> zip file
> (https://www.databasejournal.com/features/msaccess/article.php/3513061/Simple-FTP-Methods-from-Microsoft-Access.htm)
> 
> Thanks,
> 
> -paulw

FTP.exe is a command line program in Windows that you can use interactively. When you enter FTP ftp.amazecreations.com at the command line, the 14 year old site times out instead of asking for your userid and password.

Test the FTP server you are trying to connect to manually from the command line first. You'll need the name of the server, userid and password. Next, build a batch file that opens a script.  The Database Journal and MVPS links both outline this technique. Third, you can use VBA to create the batch and script files and call the batch from Access as outlined in Database Journal.

I have found WinSCP from https://winscp.net/eng/docs/guide_automation to be a more reliable and flexible FTP client than FTP.exe. With it, you can put all the commands on one line and avoid having to create the text files.

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-03 21:32 -0700
  FTP a file(s) using MS Access Mal Reeve <mal.reeve@gmail.com> - 2019-09-04 04:18 -0700
    Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-04 10:10 -0700
    Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-04 15:18 -0700
    Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-04 15:22 -0700
  Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-04 20:14 -0700
    Re: FTP a file(s) using MS Access Ron Paii <ron81pai@gmail.com> - 2019-09-05 04:55 -0700
      Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-06 10:08 -0700
        Re: FTP a file(s) using MS Access Ron Paii <ron81pai@gmail.com> - 2019-09-09 05:33 -0700
          Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-10 11:44 -0700
            Re: FTP a file(s) using MS Access Ron Paii <ron81pai@gmail.com> - 2019-09-10 12:38 -0700
              Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-11 15:33 -0700
                Re: FTP a file(s) using MS Access Ron Paii <ron81pai@gmail.com> - 2019-09-12 06:04 -0700
                Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-12 14:39 -0700
              Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-16 12:03 -0600
  Re: FTP a file(s) using MS Access samxjones2@gmail.com - 2019-09-05 06:11 -0700
    Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-05 14:46 -0700
    Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-05 14:57 -0700
    Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-06 12:06 -0700
      Re: FTP a file(s) using MS Access Patrick Finucane <patrickfinucanetx@gmail.com> - 2019-09-08 12:35 -0700
        Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-08 21:03 -0700
  Re: FTP a file(s) using MS Access Ron Weiner <rw@domain.com> - 2019-09-05 10:55 -0400
    Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-05 13:38 -0700
      Re: FTP a file(s) using MS Access Ron Weiner <rw@domain.com> - 2019-09-05 15:49 -0400
        Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-06 10:00 -0700
          Re: FTP a file(s) using MS Access Ron Weiner <rw@domain.com> - 2019-09-08 16:05 -0400
  Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-12 10:47 -0700
    Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-12 11:16 -0700
    Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-14 12:02 -0600
  Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-20 17:04 -0600
  Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-20 17:31 -0600
    Re: FTP a file(s) using MS Access "Phil Hunt" <abc@nowhere.com> - 2019-09-23 12:37 -0400
      Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-23 17:28 -0600
        Re: FTP a file(s) using MS Access Patrick Finucane <patrickfinucanetx@gmail.com> - 2019-09-23 17:56 -0700
          Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-23 20:47 -0600
        Re: FTP a file(s) using MS Access "Phil Hunt" <abc@nowhere.com> - 2019-09-24 08:47 -0400
          Re: FTP a file(s) using MS Access Ron Weiner <rw@domain.com> - 2019-09-24 13:55 -0400
            Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-24 16:24 -0600
              Re: FTP a file(s) using MS Access Patrick Finucane <patrickfinucanetx@gmail.com> - 2019-09-25 09:57 -0700
                Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-25 17:18 -0600
            Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-25 15:29 -0600
  Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-24 15:58 -0600

csiph-web