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.

 

[liamfitz]

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

 

[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.