Transfer from external Microsoft Access 2000 database

[Bill Stanley]

I wish to transfer information from a Microsoft Access 2000 database located
on an externally hosted web server from which I only have FTP access to an
office based MS Access database.

I would like to know, if this is possible, is DOCMD.TRANSFERDATABASE the
correct command to transfer information via FTP and if so what is the syntax
for specifying the remote database in the command? Access to the remote
database requires a user name and password. If DOCMD.TRANSFERDATABASE is not
the correct command, please advise what is correct.

 

[Joe Fallon]

It cannot be done using FTP.

FTP is a file transfer protocol - so all it can do is bring the remote file
to your local workstation.

That is what you need to do.

Once the file is local, you treat it like any other .mdb file and link or
import data.

You can use code like this to implement FTP in Access:

http://www.mvps.org/access/modules/mdl0015.htm