none
How to disable multiuser on Access for Office 365

    Question

  • Me and my company partner is using Access for stock management. But we are facing a problem when both of us is opening the database at the same time. The one who opened the database latest, will not be allowed to save the database. Instead there will be created a copy of the file. This means that every change made by the last user will not be stored in the original database.

    We are using Sharepoint and I cannot find a way to make this work.

    Instead I got the idea to block the database for user number 2. So if the database i s already opened, it will not allow any other users to open it.

    But I cannot find a way to do this. Is there anybody who can assist me?

    Thanks:-)

    Saturday, January 12, 2019 9:38 PM

All replies

  • Is your database split and each user given there own copy of the front-end?

    Daniel Pineault, 2010-2018 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    Sunday, January 13, 2019 1:50 AM
  • This is how Access is designed. While several users can add/edit/delete data at the same time, only the first user to go into a design view can make design changes. This is done to preserve object integrity. If you both want to make design changes you will have to either schedule who will be making the changes or use something like GitHub to check the database file in and out which will save historical versions.

    Another way that is less safe would be for each of you to make design changes to a copy of the database and then import the changes into the working file.

    What I do is split the database as Daniel implied. Keep a development copy for each of you, one test copy and one production copy of the front end.

    Both dev and test should use a test copy of the tables. Make design changes in your dev. Test in the test environment. If testing goes well export the changes to the production file. That way production is never compromised.


    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    Monday, January 14, 2019 4:56 PM