Wednesday, August 1, 2018
Access 2007 The Database Has Been Placed in a State by User on Machine That Prevents It From Being Opened or Locked
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 isnt 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.
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 isnt 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.
