Creating Linked Tables On Remote Server

[peridian]

Hello,

If I have an Access database on a remote server in a shared drive, which contains linked tables to csv files on that servers C: drive, but that are not present on my local disk, how can I get the code in the database to re-create those links?

Any attempt to use TransferText or CreateTableDef runs into the same problem, when it tries to append the newly created linked table to the database it complains that the file does not exist. This is because the files are not visible to the machine running the code.

Regards,
Rob.

[janders468]

By not visible to the machine running the code, do you mean you don't have permissions to view them, or you're not able to accurately point to the server? If you could post the code you are using I can maybe help you with it.