Microsoft KB Archive/824274

= Determine who opened a Microsoft Office Access 2003 database in the exclusive mode =

Article ID: 824274

Article Last Modified on 1/17/2005

-

APPLIES TO


 * Microsoft Office Access 2003

-



This article applies only to a Microsoft Access database (.mdb).

Moderate: Requires basic macro, coding, and interoperability skills.



For a Microsoft Access 2002 version of this article, see 289580.



For a Microsoft Access 2000 version of this article, see 289580.



SUMMARY
In a Microsoft Office Access 2003 environment, you may not be able to determine who opened an Access 2003 database in the exclusive mode. However, you can use the operating system utilities to determine who is using shared resources on your computer.



MORE INFORMATION
When you open an Access 2003 database, Access 2003 typically creates a lock file with the same name as the database file. This lock file has an .ldb extension. The .ldb file contains the information about who opened the Access 2003 database and about the computer that was used to open the Access 2003 database. However, when a user opens an Access 2003 database in the exclusive mode, Access 2003 does not create a lock file with an .ldb extension. Therefore, Access 2003 cannot use the .ldb file to determine who opened the database in the exclusive mode. If you try to open an Access 2003 database and another user has already opened the database in the exclusive mode, you receive the following error message:

Could not use ' \ :\WINNT\SYSTEM32 folder on your computer. If the Server Manager utility is not available, install the Server Manager utility and then monitor the concurrent users of the computer resources.

