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

  • 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?

    Thursday, February 1, 2018 6:26 PM

All replies

  • Check the record locking property in the File>>Options>Settings page.
    Thursday, February 1, 2018 8:44 PM
  • 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

    Thursday, February 1, 2018 9:36 PM
  • 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
    Monday, February 5, 2018 3:06 PM
  • 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?

    Monday, February 5, 2018 3:35 PM
  • 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

    Monday, February 5, 2018 10:10 PM