Transfer from external Microsoft Access 2000 database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bill Stanley - 03 Sep 2004 21:09 GMT

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.

Reply to this Message

Joe Fallon - 04 Sep 2004 03:24 GMT

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

Signature

Joe Fallon
Access MVP

>I wish to transfer information from a Microsoft Access 2000 database
>located
[quoted text clipped - 8 lines]
> not
> the correct command, please advise what is correct.

Reply to this Message