ACCESS VBA to transfer files to ftp server

From: Shirley (Shirley_at_discussions.microsoft.com)
Date: 03/09/05


Date: Wed, 9 Mar 2005 09:19:03 -0800

I have a requirement to transfer files from/to and delete files in a ftp
server from Access 200 database in local driver using VBA. I have read some
Q&As on this matter in Newsgroup, most of them pointed to www.mvps.org site.
I did download the library as suggested.

Questions are:

1. How to add those classes to my ACCESS and which files need to be added?
The Access add-in window doesn't have anything I can point to the downloaded
location;
2. The downloaded package doesn't have the sample ACCESS file as mentioned
on web site. I hope the code on web site is sufficient.
3. I also need to delete the file in ftp server after it is copied over to
local drive. What new codes and new classes are needed?

Other solutions are also greatly appreciated. Just remeber I am using Access
200 VBA from a local computer to transfer files to a ftp server.

Thank you in advance!

Shirley



Relevant Pages

  • Re: importing problems
    ... I am trying to transfer files one by one via (to a floppy ... time I try to import - it asks for a server and then says ... >need to use a 3rd Party FTP application. ... >FrontPage Resources, WebCircle, MS KB Quick Links, etc. ...
    (microsoft.public.frontpage.client)
  • Using FTP functionality in a program
    ... to transfer files from any one of a number of workstations to a Linux ... available on the server, FTP being the obvious example. ... BTW if this is wildly off-topic do please say so; the list of Linux ...
    (comp.os.linux.networking)
  • Re: Using FTP functionality in a program
    ... > to transfer files from any one of a number of workstations to a Linux ... > available on the server, FTP being the obvious example. ...
    (comp.os.linux.networking)
  • Help with IPFW + NATD + Passive FTP
    ... passive FTP connections through IPFW with NATD enabled. ... $cmd 005 allow all from any to any via dc0 ... # Interface facing Public internet ... # Allow out access to my ISP's Domain name server. ...
    (freebsd-questions)
  • RE: Client Computers cannot upload or download from Remote FTP ser
    ... SBS External NIC - Cannot FTP From this server ... SBS Internal NIC ... FTP server is Checked in Routing and Remote Access - Internet Connection - ...
    (microsoft.public.windows.server.sbs)

Loading