How do I trace down user of Access database?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm locked out from an Access mdb created originally by myself.
I get a warning like I can only open it in Read Only because it's opened by
someone else at the same time.
Is there a way to trace down the user so I can alert him or her to get out
of the mdb.

I need to resume the right of changing the mdb.

If you think there might be other reasons which prevent me from changing the
mdb, please advise how I can get rid of the error message.
 
Hi DWZ,

This can happen if there is a left over locking database file (*.ldb)
hanging around. The following KB article discusses causes of this, which
include the last user exiting does not have delete privlege, or the database
is starting to corrupt:

Introduction to .ldb Files
http://support.microsoft.com/?id=299373

Try downloading the AppUser tool from the MVPS website:

http://www.mvps.org/access/modules/mdl0055.htm


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

I'm locked out from an Access mdb created originally by myself.
I get a warning like I can only open it in Read Only because it's opened by
someone else at the same time.
Is there a way to trace down the user so I can alert him or her to get out
of the mdb.

I need to resume the right of changing the mdb.

If you think there might be other reasons which prevent me from changing the
mdb, please advise how I can get rid of the error message.
 

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

Back
Top