Network Drive Letter

[Ken]

I am using a front-end back-end database on a network
server. Not all users map to the same network drive
letter, so the linked tables dont work unless they have
the database on the correct drive.

Is there a way of checking what drive letter a network
path is mapped to and refresh the linked table manager to
the users drive letter on opening the database.

Thanks

 

[Tony C]

Rather than do this, link your Tables by specifying the
full server path, rather than using a drive letter: -

Instead of X:\Databases\Data\MyDatabase.Mdb

Use \\MyServer\Databases\Data\MyDatabase.Mdb.

Tony C.