KB199252 - 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 '<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."

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

208778 Introduction to .ldb Files

Additional query words: inf couldn t

Keywords: kbenv kbinfo kbnetwork KB199252
Technology: kbAccess2000 kbAccess2000Search kbAccessSearch