Linking Tables

[DeutchBose]

When I link outside tables/spreadsheets etc. in Access, is there any way to link it without the drive letter...When I go to my linked table manager it shows the table and path as such:

G:/file/file/file/data.mdb

but I need it to show

//pathname/file/file/file/data.mdb

We have several people using this database from different locations so drive letters are different from person to person.

Thanks

 

[Dugantrain]

\\YourServer\YourPath\YourSubPath\YourFile.mdb

should do the trick.