Exclusive Lock msg on Database in Access 2007

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

Brent Spaulding \(datAdrenaline\)

What are you trying to do in code that raises this message? Also, what is
the exact verbage of the message?
 
J

JCIrish

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top