Re: Who has locked the mdb

"paii, Ron" <paii@xxxxxxxxxxxxxx> schreef in bericht
news:7NadnSrnO4IPQ6jbnZ2dnUVZ_qarnZ2d@xxxxxxxxxxxxxx

"salad" <oil@xxxxxxxxxxx> wrote in message
news:XuiZh.5351$Ut6.1296@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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


If Access security is not being used, all users will be listed as Admin.
You
can used Windows file share utilities to show which computers have the
file
open.

Why do you need to make sure no one is in the mdb? Are the 5 users opening
the same front end. If so, split the database into a front end, back end,
giving each user a copy of the front end. This should eliminate the need
kick all other users out of the database.

In this case we had to make sure on one was in the mdb because of several
global replace en delete actions. These actions were made on a copy of the
database (after people exited the mdb). We had to make sure no one would
edit records in the mean time.

Thanks to you both...
john


.

Relevant Pages

  • 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)
  • Who has locked the mdb
    ... We have an mdb for about 5 users. ... From the ldb we then see that some one is in the database. ...
    (comp.databases.ms-access)
  • (no subject)
    ... - LDB locking which a persistent recordset connection fixes ... New format of Access 2000 MDB ... Place backend MDB on the root of the network share rather than several folders down ... Subdatasheets are a new feature in Access 2000 Therefore, you are more likely to notice this behaviour after you convert a database from an earlier version. ...
    (comp.databases.ms-access)
  • Re: temp db
    ... If the database is not in use, you can create a copy just by copying the MDB ... The purpose is to create a temp db for all the ... ' This subroutine illustrates how to use a temporary MDB in your app. ...
    (microsoft.public.access.formscoding)
  • RE: Access to Access Automatic Updates
    ... Then navigate to the database from the File Open dialog and open it. ... You will need to do it for mdb that has tables you need ... MS Office Master 2000 ed. ... you will need to create a form that opens on ...
    (microsoft.public.access.externaldata)