Who Has Databases Open? 2

[UkMister]

Hi

Is it possible to tell who has copies of a networked Access 2000 database open?

We run a W2K network with Office 2000. As you probably know, there is an 'exclusive lock' feature in Access 2000 which means that anyone changing the design of a database needs an exclusive lock before any changes can be made.

If another person has the database open, the person responsible for making the design changes cannot, since they need the exclusive lock, which means that the other person using it must come out.

We have a problem where we don't know who else has the DB open. So without having to phyically go round and check every single machine, is there a way, from the server etc, I can tell who has it open??

Many Thanks

 

[dhutch75]

When you open a database, a new file with an extension of '.ldb' is created. This is a simple text file that can be read using notepad, which lists all the users that are currently logged into the database. Occasionally, if a user terminates the program badly (lockup, network failure, etc.) their name will remain in the file when they are no longer in the database. If you delete the .ldb file, making sure that all users are truly out, Access simply recreates it as soon as someone opens the file again.

 

[UkMister]

Many thanks dhutch