Friday, April 27, 2012

Access 2007: The Database Has Been Placed in a State by User on Machine That Prevents It From Being Opened or Locked

Problem:  You get the message "The database has been placed in a state by user on machine that prevents it from being opened or locked" when you try to open a shared database over a network.  The database can only be opened by one person while the others receive the above message.

Solution:  The database should automatically open in shared mode, but network security settings may interfere with this.  Try one the following:

1)  Does the first person opening the database see a notification at the top that warns "Security Warning: Certain content in the database has been disabled".  If so, then click on the "Options..." button, select "Enable this content" and click OK.  The notifications should disappear and others should now be able to open the database, but should also Enable the content in the same manner.

To fix this in a more-permanent manner, from the "Options..." button given in the warning, click on the "Open the Trust Center" link at the bottom of the window the appears.  From within the Trust Center window, go to Macro Settings (on the left) and select "Enable all macros".  From now on the security warning should not appear.

2) If you do not see a security warning as describe above, the security settings could still be a problem and Access just isn't notifying you.  In Access, click the Office button in the upper-left corner, select "Access Options", select "Trust Center" from the left menu, and then click the "Trust Center Settings..." button.  From the Trust Center, select "Macro Settings" from the left menu and choose "Enable all macros" from the options.
3)  Create a shortcut to the database by right-clicking the Access file, selecting "Send to >" and choose your Desktop.  From now on, open the database from the shortcut on your desktop.  Solutions #1 and #2 may still apply to this setup.

14 comments:

  1. This doesn't usually fix the issue.

    ReplyDelete
  2. I have macro in my database had this problem, this solved my problem, thank you.

    ReplyDelete
  3. This worked for me

    ReplyDelete
  4. Thank you very much!

    ReplyDelete
  5. If this doesn't work, try making the location that the .accdb file is stored in a 'trusted location' through the 'trust center'. That fixed it for me.

    ReplyDelete
  6. Didn't work for me.

    ReplyDelete
  7. Following #2 for my .accdb database worked for us! Thanks

    ReplyDelete
  8. Option 2 did it for me. Thanks Buddy

    ReplyDelete
  9. Enabling all macros worked for me. But, you have to close out the database and reopen it for it to take effect.

    ReplyDelete
  10. None of these options worked for me. It still refuses to open connection a second time... even though connection has been closed!

    ReplyDelete
    Replies
    1. I'm going nuts. Nothing on this page worked for me. Aaaaaaaaah!!!

      Delete
  11. There is an option in client settings to lock at record level (advanced towards bottom). Try un-checking that if it is checked.

    ReplyDelete
  12. Hi How to fix the The Database Has Been Placed in a State by User on "admin" That Prevents It From Being Opened or Locked in 2003 or .mdb file with multiple user with programming language VB6.0

    ReplyDelete
  13. I was able to resolve this issue ("The Database Hs Been Placed in a State...") be deleting the links to Sharepoint tables.

    ReplyDelete