Access back-end will not fully open with 2 or more users

Question

I have a split Access 2016 database with 4 users. Each of them are running a copy of the front-end on their computers.  Recently if I attempt to open the back-end and there are at least 2 font-ends open the back-end opens very slowly and after 2-3 minutes of the busy wheel it stops and fails to load any objects. Just a blank screen with a menu bar and a completely empty object menu. If I attempt to do something I get message "Your network access was interrupted . . to continue please close the database and open it again".  It opens fine with no open front-ends.  Any ideas?

 

Answer 1

Check the record locking property in the File>>Options>Settings page.

Answer 2

Why are you opening, working with, the back-end while it is in production?

If you need to perform development, or admin maintenance, ... then you should be working off of a local copy with no one in it.

---

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

Answer 3

I need to open the back-end while in use because it has a macro that lists the machine IDs of everyone who has a front-end open.  That way I can contact the individuals and ask them to close their FEs I can work on the BE

Answer 4

I have it set to Default Record Locking: No Locks.

Also "Open databases by using record-level locking" is checked.

Should I un-check that?

Answer 5

The back end isn't directly open-able when others are in use.  Choices are:

a. link to it via a front end for table data view ability, and other objects in its navigation pane.

b. copy it - to inspect the entire db as a single user

c. wait until all are out of the database