I have a frontend and backend database put in a network drive where users can access to the frontend version which has tables linked to the backend.

When I set up the link tables from the frontend to the backend, Access points to a local drive letter in my computer. For example, if I map the network drive where the databases are, say to Drive R:, the link table in the frontend will always point to tables in the backend on R:. If other user map the same network drive to drive letter other than R:, the table links between the frontend and the backend will be broken.

I wonder if anyone knows a way to set up table link with a physical path instead of a local drive letter?

Thanks

Mike :rolleyes:

When you link, rather than navigating through the mapped drive, drill down through Network Places, which will give you a UNC path:

\\ServerName\ShareName\FileName.mdb

pbaldy,

It works. Thanks for enlightening me.

Mike