Exclusive Lock msg on Database in Access 2007

  • Thread starter Thread starter JCIrish
  • Start date Start date
J

JCIrish

How to deal with the message that Access requires an exclusive lock on the
data base (for example when I come back to modify VBA code in a standard
module)? The message says that the user, "admin" (which is me!) has done
this? The file extension does not indicate that it is locked. I am the only
user of the database.
The computer lives on a home network but the databse can't be accessed by
any other machines on the network. OS is Vista 64 bit.
 
What are you trying to do in code that raises this message? Also, what is
the exact verbage of the message?
 
I think the complete mesage is, "The database has been placed in a state by
user "Admin" on machine "Test-Pc" that prevents it from being opened or
locked. (In looking through some help screens I found a discussion of
exclusive use on databases with multi-users, which is not applicable to my
situation)

The specific runtime error is-2147467259(8000-4005)
 
Back
Top