Unable to open DB, more than one user ?

[liamfitz]

The following message appears, when more than one user tries to access my DB ( Access 2010 ), which is on a common drive to all users ( P

The database has been placed in a state by user 'Admin' on machine 'VISTAJJ' that prevents it from being open or locked

Thank you in advance.

 

[Pat Hartman]

When you open an Access database, Access creates a lock file in the same directory. This file is used to manage concurrent user access. If (because of permissions) Access cannot create this lock file, it opens the database with an exclusive lock which prevents others from opening it. The last person to exit the database will cause Access to close and delete the lock file.

Verify that all users have "CRUD" permissions for the directory that holds the BE.

The other possibility is that someone (or perhaps code in your application) is making modifications to database objects such as forms/reports/code. A2007 and newer prevent multiple users if one is making design changes.

 

[liamfitz]

Thank you Pat, that's very informative. What is/are CRUD and BE ?

 

[Pat Hartman]

Create, Read, Update, Delete. BE = back end. FE = front end. The BE contains ONLY tables. All the rest of your application objects should be in the FE. The BE must be shared and so is stored on a network drive available to all the application users. The FE is distributed so that each user has a private copy on his local C: drive.

 

[liamfitz]

Thanks again Pat. I'm working on it now.

 

[bluetongue]

Another siyuation which can generate this message - if you have multiple users using a networked database that is not split into front and back ends then any user who hits the save button will lock the rest out.

 

[Rabbie]

Another siyuation which can generate this message - if you have multiple users using a networked database that is not split into front and back ends then any user who hits the save button will lock the rest out.

Hopefully this is not the case. If it is then it is a disaster waiting to happen and it won't wait long.

 

[liamfitz]

Point taken. So far so good.