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

Applies to: Microsoft Office Access 2003Microsoft Office Access 2007Access 2010

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


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 environment, you may not be able to determine who opened an Access 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 database, Access typically creates a lock file with the same name as the database file. This lock file has an .ldb or .laccdb extension, depending on what type of file is being opened (.mdb or .accdb). The .ldb or .laccdb file contains the information about who opened the Access database and about the computer that was used to open the Access database. However, when a user opens an Access database in the exclusive mode, Access does not create a lock file with an .ldb or .laccdb extension. Therefore, Access cannot use the .ldb or .laccdb file to determine who opened the database in the exclusive mode. If you try to open an Access database and another user has already opened the database in the exclusive mode, you receive one of the following error messages: 
Could not use '<path>\<database.mdb>'; file already in use.

Could not use '<path>\<database.accdb>'; file already in use.
You do not receive any information about who opened the Microsoft Office Access database in the exclusive mode or about the computer that was used to open the Microsoft Office Access database in the exclusive mode. 

You can use utility software, such as the Computer Management utility or the Server Manager utility, to determine who has an Access database open in the exclusive mode and to determine what computer has an Access database open in the exclusive mode.

For more information about how to view shared resources by using the Computer Management utility, follow these steps.

Note Because there are several versions of Microsoft Windows, the following steps may be different on your computer. If they are, see your product documentation to complete these steps.
  1. Click Start.
  2. Click Help and Support.
  3. In the Search box, type
    Computer Management.
  4. Click Start Searching to view the topics.
  5. Search the Computer Management utility Help Index for "Viewing Information About Shared Resources."
If your computer runs the Microsoft Windows 2000 operating system, the Server Manager utility may be available as an executable file (Srvmgr.exe) in the Installation Drive:\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.

References


For additional information about using the Server Manager utility to monitor the concurrent users of the computer resources, see the "Viewing: User Sessions" topic in the Server Manager Help Index.

For additional information about installing the Server Manager utility, click the following article numbers to view the articles in the Microsoft Knowledge Base:

237995 Installing Usrmgr.exe and Srvmgr.exe in Windows 2000 Professional

173673 Windows NT Server Tools for Windows NT Workstation 4.0 available



For additional information about .ldb files, click the following article number to view the article in the Microsoft Knowledge Base:

299373 Introduction to .ldb files