problem with .ldb file

[pesto]

When I try to open an one of our access databases, I get this error.

The database has been placed in a state by user 'Admin' on machine '98suf89s87d89s' that prevents it from being opened or locked.

I did an exclusive open earlier today and since that time, I haven't been able to get back into the database. I can right-click and open, but cannot change anything. I can also copy the database and open the copy, but then I cannot delete the locked copy, because "a user has the database open" (not likely).

Any help would be greatly appreciated.

 

[pesto]

I did a quick search and found this thread.

http://www.access-programmers.co.uk/forums/showthread.php?t=111240&highlight=security

I opened the .ldb file in Notepad and here is what it says.

08FSA53113LH Admin 08FSA53113LG Admin

I can't think who Admin would be, unless that's a consequence of opening the database exclusively.

 

[pesto]

Well, the problem seems to have fixed itself. Thanks for your help everyone. ;-)

 

[ghudson]

08FSA53113LG = the computer name that had the db open

Admin = the current user name of the workgroup that the user was joined to when they opened the db. Admin is the default.