Terri Cannon
asked on
Moving database to a shared server
I created an access data base on my desktop. I split the data base and saved the backend in a folder on a shared server. Then I saved a copy of the front end from my desktop to another folder on the shared server. I can get into the front end and backend database on the server, but most of my coworkers cannot. Some are getting an error that the path is not valid and some are getting an error file cannot be found. There are a few that have no problem at all. Any suggestions as to why some can get in and other can't?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
How do I get to the relink dialog to paste in the UNC path?
Right click on any table name. Choose Linked Tables Manager from the dropdown list. You will need to paste in the path to the server or you might be able to get to it by starting with Network and drilling down. I usually just paste in the path I want.
ASKER
Open any Access database. Go to Files/Options/Trust center. Press the trusted locations. Set the path in the message to trusted. Close Access and try the linked tables manager again.
ASKER
Thank you for your assistance. Pasting the path worked.
I would not allow users to share the FE that is on the server. Instead, have them copy that file to their desktop and run it from there.