Accessing an Access database via FTP

[Mark Casey]

Hopefully someone can help!

Is there any code around which can assist with connecting to an Access 2k3
database via an FTP connection, any suggestions or links to code would be
gratefully accepted, have tried various places but to no avail. I would'nt
normally P people off unless I was desp.

Regards


Mark

 

[Naresh Nichani MVP]

Hi:

You cannot access an Access database via FTP to the best of my knowledge.
You can use ASP or ASP.Net code or call a Web Service from VBA code in
Access (Web Service would talk to Access) to do the work. This would be done
via HTTP.

FTP can only download and upload files and you cannot open an Access
database connection over FTP.

Regards,

Naresh Nichani
Microsoft Access MVP

 

[Douglas J. Steele]

If you mean using FTP to let you get at the data in tables, etc., it's not
possible. Access doesn't recognize the FTP protocol (nor the HTTP protocol,
for that matter)

If, on the other hand, you're strictly talking about using FTP from within
Access to transfer files to and from an FTP server, take a look at
http://www.mvps.org/access/modules/mdl0015.htm and/or
http://www.mvps.org/access/modules/mdl0037.htm at "The Access Web". While
the second example is coded for Access 97, it shouldn't be that difficult to
upgrade to Access 2003.