Open exclusive by user XXXX

[stevens]

How do you get past the message that a database is open exclusively by user
admin on machine XYZ when your computer is XYZ and you are the one trying to
open the database?
Steve S

 

[Joseph Meehan]

How do you get past the message that a database is open exclusively by
user
admin on machine XYZ when your computer is XYZ and you are the one trying
to
open the database?
Steve S

Usually this means Access did not close properly the last time it was
used. Close the database and then look to see if there is a
NAMEOFDATABASE.LDB file in addition to your NAMEOFDATABASE.MDB file. Delete
the LDB (Locking DataBase) file.

 

[Van T. Dinh]

Close Access completely and try to find the {DatabaseName}.ldb (a locking
file) in the same directory with the database file. Delete this file (*make
sure* it is the ldb file) and then try opening the database again.

If you still get the same message, then it is possible that your database
file is corrupted. In this case, see Tony Toews' article:

http://www.granite.ab.ca/access/corruptmdbs.htm