Hi,
I have a db with the tables linked between a BE and FE. It resides in a folder on the server \\server001\RBRS\ and I want the users to be able to copy the FE down onto their own desktop with the shared BE residing on the server.
When users copy the FE onto their desktops do they need to refresh the links to the tables?
Also, when I look in Linked Tbale Manager I see that the directory (take the BE as an example) structure/address is x:\Tables\RBRS - TABLES.mdb
Now x is just the drive letter I used when I mapped that folder from the server; the correct address for the location of that db is \\server001\RBRS\Tables\RBRS - TABLES.mdb
How can I get Access to use this as the address for the tables? I will encounter problems when users start mapping this drive on their own machines to download the FE if I'm stuck with the x:\ convention.
Liam
I have a db with the tables linked between a BE and FE. It resides in a folder on the server \\server001\RBRS\ and I want the users to be able to copy the FE down onto their own desktop with the shared BE residing on the server.
When users copy the FE onto their desktops do they need to refresh the links to the tables?
Also, when I look in Linked Tbale Manager I see that the directory (take the BE as an example) structure/address is x:\Tables\RBRS - TABLES.mdb
Now x is just the drive letter I used when I mapped that folder from the server; the correct address for the location of that db is \\server001\RBRS\Tables\RBRS - TABLES.mdb
How can I get Access to use this as the address for the tables? I will encounter problems when users start mapping this drive on their own machines to download the FE if I'm stuck with the x:\ convention.
Liam
