Stubborn Table Link To Internet

[Guest]

Hi all,

Anyone has an idea on how to link a table on local computer to a database on
an Internet Server?

Or

How do we modify the linking path of the table manually (Type in) instead of
using Linked Manager Wizard. The reason is I am going to upload this database
to the server where it will find the linked database by itself on local
machine.

The problem now is I can't set the path on my computer as it will turn the
path to be absolute path which the server will not recognise.

Thanks in advance

 

[Guest]

Don't use the wizard.
To set it up initially, use the Tools, Database Utilitiles, Linked Table
Manager.
Check the "Always check for new location" check box.
Type the link in as a UNC path rather than a Drive Map path:
\\ServerName\Folder\SubFolder\foobar.mdb

Then, regardless of how a user has his drives mapped, it wont matter.

 

[Guest]

Hi,

Thanks for replying.

However, the server is not in my local area network. It says that not a
valid file name and could not find the server.

Thanks a lot.