Re: Who has locked the mdb

John wrote:
We have an mdb for about 5 users. They don't have to log in to get into the mdb, they just open it. However, sometimes we need to make sure no one is in the mdb. From the ldb we then see that some one is in the database. Is there some way to find out which user in still in the mdb?
Thanks,
john


Well, I believe it depends on the version of Access. I think A97 used LDBView. After 97, see if http://support.microsoft.com/default.aspx?scid=kb;en-us;285822 works.

You might also want to look for msldbusr.dll in google groups

.

Relevant Pages

  • Re: how do you burn cd of old database
    ... Thank you for the help John. ... and the "Hide extensions for known file types" was already unchecked. ... Find the mdb file's icon and drag ...
    (microsoft.public.access.externaldata)
  • Re: Who has locked the mdb
    ... can used Windows file share utilities to show which computers have the ... If so, split the database into a front end, back end, ... In this case we had to make sure on one was in the mdb because of several ...
    (comp.databases.ms-access)
  • Re: Migration and authorisations
    ... John wrote: ... We have one mdb and an associated mdw that now gives us trouble. ... If the users try to open the mdb they get the message: ... You did not mention the database and version or anything like that so you are probably not going to get much usable help. ...
    (comp.databases.ms-access)
  • Re: How to capture last used date/time
    ... On Aug 20, 6:08 pm, John W. Vinson ... reminds me, did you say in another thread you have a technique for ... ensuring the mdb is only accessed via one application? ...
    (microsoft.public.access.gettingstarted)
  • Re: multi-level table linking
    ... end from data tables, same as a traditional splitting of a single MDB, thus ... John G. ... tables link into the middle MDB fine, but the "Get External Data" dialog ...
    (microsoft.public.access.externaldata)