Share via

Access database and locked by Admin

Anonymous
2012-07-05T17:51:57+00:00

We sahre an access database that is on a network disk.  Occasionally when another person tries to access the database, they get a message that states that it is locked by Admin on FrontDesk (A PC in our workgroup.  How can we prevent this from happening?  Currently all have to logoff of the database and then reopen it.  Seems that we have somehting not setup correct.  Access DB 2010.  Thanks.

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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2012-07-05T18:06:57+00:00

    A multiuser database should - I'd say for 2007 and later versions must - be "Split" into a Backend (containing just the tables) and a Frontend, containing links to the tables along with all the queries, forms, reports and code. A2010 requires that the user have exclusive access to the database if they are doing ANYTHING involving VBA code (opening a code-bearing form or report in design view, for example). Or of course the user on FrontDesk may be opening the database exclusively.

    Split your database (using the Database Splitter Wizard) and give each user a copy of the frontend on their own C: drive. This will prevent both this error and the much more serious risk of bloating and corruption of the shared database.

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments