relative links for linked tables

[DaveMere]

Hi,

I'm buliding an access system in which the forms and tables stored in seperate databases as such:

forms: \\server\dir\myDatabase.mdb
tables: \\server\dir\data\myTables.mdb

myDatabase has a load of linked tables from myTables. Problem; my network drives are mapped differently from the users, so the links do not work for me.

So - does anyone know how I can set up a relative link, so myDatabase looks for \data\myTables? i.e. it looks from the source directory rather than checking the whole path back to the root?

Hope this is making sense . . .

Dave

 

[Sergeant]

IF you type in the absolute path \\server\share\share\db.mdb when you link the table, it should work throughout the network.

 

[DaveMere]

Of course . . . I had the tables linked to the network maps rather than the absolute path.

Many thanks Sergeant!