Microsoft KB Archive/199252

= ACC2000: Determining Which User Has Opened Database Exclusively =

PSS ID Number: 199252

Article Last Modified on 3/6/2001

-

The information in this article applies to:


 * Microsoft Access 2000

-



This article was previously published under Q199252



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

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

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



SUMMARY
Unlike earlier version of Microsoft Access, Access 2000 does not create an .ldb file when a database is opened exclusively. Because of this, you can no longer use the .ldb file to determine which user has a database opened exclusively.

You must use an operating system tool, such as NetWatcher (a utility that comes with Microsoft Windows) or the Windows NT Server Manager, to determine which user has a Microsoft Access database open exclusively.



MORE INFORMATION
When you try to open a database that is opened exclusively by another user, you receive the following error message:

Couldn't use ' \'; file already in use.

You receive no information about the user or machine name.

