Do Not Have Exclusive Access

[access2010]

One of the students in our office made some changes to our Access 2003 Database and now we get this error message when we try to modify a form.

"You do not have exclusive access to the database at this time. If you proceed to make changes, you may not be able to save them later."

Your suggestion is appreciated.
Nicole

 

[The_Doc_Man]

Exclusive access occurs when someone triggers a particular setting. In newer versions of Access, this is File >> Options >> Client Settings >> Advanced, and the setting says "Default open mode is" - then you can check Exclusive or Shared. I'm not exactly sure where that is on older versions, but it is an option you can set for a particular database file.

Exclusive access also occurs when there is a problem with the lock file (.LDB for that version.)

I'm betting on the Open Mode being set to Exclusive and the person left the database open from his/her workstation so the file is now locked in Exclusive Write mode. Make that person's PC shut down for a moment and the problem should resolve itself.