Forum Discussion
Microsoft Access Database 365
Is it possible to run the database allowing multiple users to work simultaneously. We have an older version of Access which is server generated and would like to continue using this program in this manner.
- What exact version of Access are you using now? You added the tag "Access Web Database" which means something very specific (and very deprecated).
Assuming that was a mistake: Access is multi-user out of the box. It should be split into a front-end to be distributed to all users, and a back-end on a file server in the LAN.I am aware that the software is multi use. We upgraded to Microsoft 365 and cannot use the access app as we did when it was installed on the DC server. I need at least 2 users to access the software and view each other work simultaneously. Sharing is not allowing this to be done. The version installed was 2007 and was upgrade to 2010. It is a desktop version not cloud base.
- You'll have to be more specific.
Do you indeed have the application installed as I outlined, with front-end and back-end?
Assuming yes, did you re-link the linked tables to the new location of the back-end?
What if any errors are you getting? Please quote any error messages verbatim.
Given that you mentioned using Access 2010 on a desktop, here are some instructions for configuring multi-user access:
NOTE- Before proceeding with any changes, make sure to have a backup of your database to avoid any potential data loss.
- The first step is to split the Access database into a front-end and a back-end.
- The back-end (the tables) need to be stored in a network location that is accessible to all users. For instance, this might be a shared folder on a file server.
- Each user should have their own copy of the front-end, which they open on their local computer and contains forms, queries, etc. The front-end will link to the shared back-end's tables.
- Multi-user access is turned on by default in Access 2010. But, to prevent conflicts when multiple users are simultaneously updating the same record, it is crucial to set the "Default Record Locking" to "Edited record".
- Your application must be built to handle concurrency conflicts that may occur when multiple users attempt to update the same record at the same time.
- Make sure no one is changing the database's structure (tables, queries, etc.) while it is being used by others.
I hope these points will help you. 🙂
Best Regards.
