ACC2000: Determining Which User Has Opened Database Exclusively

ID: Q199252


The information in this article applies to:

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

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


SUMMARY

Unlike earlier version of Microsoft Access, Access 2000 does not create an .ldb file when a database in 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 '<path>\<database.mdb>'; file already in use.
You receive no information about the user or machine name.


REFERENCES

For more information about NetWatcher, search the Microsoft Windows Help Index for "NetWatcher."

For more information about using Microsoft Windows NT 4.0 Server Manager to view user connections, search the Server Manager Help Index for "viewing: user sessions."

Additional query words: inf


Keywords          : kbenv kbnetwork kbdta GnlMu 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbinfo 

Last Reviewed: May 13, 1999