Share via

Using Access database on multiple computers simultaneously

Anonymous
2019-07-20T02:58:38+00:00

Not familiar with access at all, someone built us a database. Its a split database it is currently on one computer and we want to get it on 3. I tried copying the front end and putting it on another computer then moving the back end to one drive and linking both front ends to the backend on onedrive. I keep getting error messages before getting to the switchboard about macros and misspelling. I am not sure what's wrong or what I could be doing wrong. I moved the original file to onedrive now the database is not working at all. I am currently doing a system restore on the computer in hopes that it will put things back where they were so the database at least functions on one computer. Not sure how I can make this work. I desperately need help!!!

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

8 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-07-20T10:55:01+00:00

    You can't use cloud-based storage like OneDrive with a multi-user Access database. The backend must be installed on a network folder that can be accessed by all users, and that folder must be set to allow Create, Read, Update, and Destroy (CRUD) permissions to all users.

    If you install the backend to that folder, you'd then relink the frontend to the backend, and then make copies of the frontend and install them to the machines that need to run your application.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  2. Tom van Stiphout 40,211 Reputation points MVP Volunteer Moderator
    2019-07-20T19:56:17+00:00

    In addition to what Scott said, the front-end also needs to be in a Trusted Location.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2019-07-28T02:46:31+00:00

    Whomever built the database put the backend in a folder not sure if its a network folder but only one computer (main computer) can access it. When when i turn on sharing for that folder the other computers cannot find the network.  If i try to move it to a new network folder for all the computers to access it will not work. I get error messages and the database will not work. Is there a way to find its location and setup a new network to move it to? At one point all the computers were on a homegroup, but that feature is no longer an option on the computer where the backend is stored. Totally not computer savvy at all. Looking for any and all help.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2019-07-28T02:40:01+00:00

    I found an older version of the backend and relinked it its working again thanks

    Was this answer helpful?

    0 comments
  5. Anonymous
    2019-07-20T08:37:39+00:00

    A win restore has no impact on data files, only settings.

    You need to move the backend back to its original location

    Was this answer helpful?

    0 comments