Linked Tables - Different Drive Letters

[paulnnosh]

Hiya,

I have a database that links to tables on my J: drive. Other users need to access this data but have mapped the same drive to their G: drive. How can I link a table to a drive name (eg //solits1/database.mdb) rather than a drive letter??

Any and all help gratefully received!!

 

[glalsop]

When you link the table, if you go through My Network Places instead of selecting the mapped drive letter, you should be able to locate the computer name by following the UNC path.

-Gary