Question on Linking of Table

D

Dirk_Bob

I copied my database and linked spreadsheet to a networked folder.
However when others try to use the database we get an error as it trys to use
the mapping of my system which does not match everyone else.

How can I link this table so that anyone can use the database regardless of
what
drive they have mapped?
 
K

Klatuu

You have to use what is known and UNC mapping. Rather than Drive Letter
Mapping:

G:\SomeFolder\SomeFile.xls

You have to define what G: is mapped to:
\\SomeServer\FirstFolder\SomeFolder\SomeFile.xls

It is always best to use this for linking because it prevents the problem
you are having.
 
Top