Microsoft KB Archive/176670

From BetaArchive Wiki
Knowledge Base


ACC: Microsoft Jet Utilities Available in Download Center

Article ID: 176670

Article Last Modified on 1/22/2007



APPLIES TO

  • Microsoft Access 97 Standard Edition



This article was previously published under Q176670

SUMMARY

The Jetutils.exe file contains the "Understanding Microsoft Jet Locking" white paper, the LDBView utility, the DBLock utility, and the Msldbusr.dll.

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.

LDBView is a 32-bit single .exe utility that can run under either Microsoft Windows 95, Microsoft Windows 98, Microsoft Windows NT or Microsoft Windows 2000, and can view both Microsoft Jet 2.x and Microsoft Jet 3.x databases.

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:

198755 HOW TO: Check Who Logged into Database with Jet UserRoster in Access 2000


.
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:

The Jetutils.exe file contains the following file:

   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
                

For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to Obtain Microsoft Support Files from Online Services


Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.


Additional query words: kbfile

Keywords: kbdownload KB176670