ACC97: Updated Version of Microsoft Jet 3.5 Available on MSL

• Microsoft Access 97

SUMMARY

The Jet35upd.exe file contains an update of two .dll files that are included with Microsoft Access 97, Microsoft Office 97 Professional Edition, and Microsoft Visual Basic version 5.0. Microsoft Jet database engine version 3.51 provides an improved Compact utility that combines Compact and Repair into a single process. Also, the updated version of the Jet database engine generates an error if it encounters a problem during the Compact process and then creates the table MSysCompactError in the destination database.

NOTE: Jetcomp.exe, which is included with Jet35upd.exe, is a stand-alone utility that allows you to compact databases created with Microsoft Jet database engine 3.x. This utility may be used in conjunction with Microsoft Jet database engine 3.51 for recovering corrupted databases. Although it is possible to use the Microsoft Access Compact utility or the CompactDatabase method with Microsoft Jet database engine 3.51, Jetcomp.exe may be able to recover some databases that these utilities could not. This is because the Microsoft Access Compact utility and the CompactDatabase method attempt to open and close a database before attempting to compact it. In certain cases where these utilities may not be able to reopen the database, Compact will be unable to proceed, preventing recovery of the database. Jetcomp.exe does not attempt to open and close the database before compacting, and may be able to recover some databases that the Microsoft Access compact utility and the CompactDatabase method could not. Jetcomp.exe is a freely distributable utility, but requires that you have one of the following products installed:

   Microsoft Office 97
   Microsoft Access 97
   Microsoft Visual Basic 5.0
   A Microsoft Office Developer Edition  97 run-time application that
     includes the run-time version of Microsoft Access 97
   A Microsoft Visual Basic 5.0 run-time application that includes
     Microsoft Jet database engine 3.5

 ~ Jet35upd.exe (size: 744160 bytes) 

   is available for download from the Microsoft Software Library. It
   contains the following files:

   Msjet35.dll    Version: 3.51.0623.4   Size: 1,045,776 bytes

   Msrepl35.dll   Version: 3.51.0623.0   Size: 407,312 bytes

   Jetcomp.exe    Version: 1.0.715.0     Size: 41,472 bytes

   Readme.doc     Installation instructions for the update and
                  additional information about the improved Compact
                  utility

MORE INFORMATION

For more information about downloading files from the Microsoft Software Library, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q119591
   TITLE     : How to Obtain Microsoft Support Files from Online Services

   ARTICLE-ID: Q170779
   TITLE     : Inconsistent Behavior with Multiple-Field Primary Query

   ARTICLE-ID: Q160893
   TITLE     : Querying Linked SQL Server Tables May Cause Error

   ARTICLE-ID: Q158933
   TITLE     : Error <Database Name> Isn't an Index in This Table