Re: Who has locked the mdb


"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.


.

Relevant Pages

  • Re: Contemplating A97 to A2003
    ... "Leslie Isaacs" wrote in message ... A2003 is more stable than A97 to develop in. ... technology such as PHP to read/write the Access database. ... > 3) a developer whose services I would like to use for some small projects ...
    (microsoft.public.access.conversion)
  • Re: Using Access 97 with Project
    ... "Earl Lewis" wrote in message ... Can the MSP2002 then read the A97 database after its converted? ... Is it possible to keep the Db created with MSP in A2k format and link ...
    (microsoft.public.access.externaldata)
  • Re: Using Access 97 with Project
    ... Can the MSP2002 then read the A97 database after its converted? ... from my A97 app and have them read by MSP. ... I think these are at the heart of my challenge Earl, ...
    (microsoft.public.access.externaldata)
  • Re: Access 2000 - Realtime Development - Should i stick with Access97
    ... Consider keeping your A97 as well as A2000. ... If a database will not convert, use A97 to decompile it first. ... By default, A2000 and 2002 do not include a reference the DAO library, so ... The "Name AutoCorrect" has myriads of bugs and performance problems. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Grouping Information in a Report
    ... Access 2000 and later have a feature called Conditional Formatting, ... The best you can do is A97 is to add a small text box ... "Glenda" wrote in message ... I have a database that tracks quality information> about parts at different stages of production. ...
    (microsoft.public.access.reports)