The white paper introduces you to the Microsoft Jet Database Engine versions 2.x and 3.x locking techniques so that you can apply the information to coding and debugging techniques when you develop multi-user applications.
The LDBView utility is used to accomplish the following tasks:
- Discover which users have been connected to the database and which users are currently connected to the database.
- Discover the values of the commit bytes in the DBH (database header page).
- Determine which user or users have left the database in a suspect state.
Note This utility was not tested with Jet 4.0 databases. For additional information about determining who is currently connected to a Jet 4.0 database, click the following article number to view the article in the Microsoft Knowledge Base:
The DBLock utility determines which types of locks Microsoft Jet is placing, which page types are being locked, and which tables are associated with those pages. DBLock is a Visual Basic 4.0/5.0 32-bit utility that runs under either Windows 95, Windows 98, Windows NT, or Windows 2000, and can work against both Microsoft Jet 2.x and Microsoft Jet 3.x databases.
The Msldbusr.dll is a 32-bit DLL that enables you to retrieve one of the most sought-after pieces of information: a list of users connected to the database. Because this is a 32-bit DLL, it will only work with 32-bit products running on Windows 95, Windows 98, Windows NT, or Windows 2000. It retrieves information for both Microsoft Jet 2.x and Microsoft Jet 3.x databases.
The following file is available for download from the Microsoft Download Center:
For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:
Jetlock.doc Understanding Microsoft Jet Locking White Paper
Readme.txt Readme file with Installation information
LDBView.exe LDBView utility
Dblck.exe Self-extracting executable that contains the
setup files for DBLock
Msldbusr.exe Self-extracting executable that contains
Msldbusr.dll and associated files
Article ID: 176670 - Last Review: Jan 22, 2007 - Revision: 1