Link to home
Start Free TrialLog in
Avatar of Terri Cannon
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
Avatar of PatHartman
PatHartman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
then you also have to make sure that all users have read/write permissions for the folder where the BE file is located.

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.
Avatar of Terri Cannon
Terri Cannon

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.
When I right click and select Linked Tables Manager from the dropdown list, the attached image appears.  I can not change the file path.User generated image   I do not see anywhere else to past the file path.
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.
Thank you for your assistance. Pasting the path worked.