I am trying to link a table in Access via ftp and have set up a TransferDatabase macro. When it is linked to the file on my c: everything works fine running locally but obviously when I upload the file to the server and try to access the information remotely I get an error: "C:\Inetpub\wwwroot\DATABASE\USER_REV.MDB' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides."

Any help as to how I can direct the file to look at the ftp site would be greatly appreciated!

Here are the macro arguments:

Tranfer Type - Link
Database Type - Access
Database Name - user_rev.mdb
Object Type - Table
Source - Review
Destination - Review
Structure Only - No

If you read the documentation, you'll see that the DatabaseName is supposed to be the complete path. If you want to link to a db on an ftp site, you'll need to specify the path to the server as well. Use the UNC naming convention.

//server name/path/db.mdb

BTW, macros are not flexible and they should never be used in a database that you intend to be used by others since they do not provide any error trapping capabilitits. Convert the macro to code so you can specify the remote server via code if necessar.