Updated Version of Microsoft Jet 3.5 Available on MSL

ID: Q172733

The information in this article applies to:

SUMMARY

The Jet35sp2.exe file contains an update of four .dll files that are included with Microsoft Access 97, Microsoft Office 97 Professional Edition, Microsoft Visual Basic version 5.0 or later and other products that incorporate Jet 3.5x. 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 Jet35sp2.exe, was updated on September 1, 1998. You can now use Jetcomp.exe on secured databases and databases that have a database password. Jet35sp2.exe now includes Jet 3.52 (MSjt4jlt.dll). Jet 3.52 only works with Jet's OLE DB provider and/or ADO going to Jet data via the Jet OLE DB provider. For additional information, see the following article in the Microsoft Knowledge Base:

Q190463 What is MDAC, DA SDK, ODBC, OLE DB, ADO, RDS, ADO/MD?

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

The user interface of JetComp.exe is in English only and is not supported by Microsoft Product Support Services. However, JetComp.exe can be used to compact databases in any language supported by the Microsoft Jet database engine. Jetcomp.exe is a freely distributable utility, but requires that you have one of the following products installed:

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

   File Name      Version       Size
   ----------------------------------------------
   Msjet35.dll    3.51.2723.0   1,046,288 bytes
   Msrepl35.dll   3.51.2404.0   415,504 bytes
   Msjt4jlt.dll   3.52.2723.0   1,234,704 bytes
   Msexcl35.dll   3.51.2723.2   250,640 bytes
   Jetcomp.exe    1.0.1526.0    39,424 bytes

   - and -

   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:

Q119591 How to Obtain Microsoft Support Files from Online Services
For information about existing problems that may be resolved by the Updated Version of Microsoft Jet, please read the following articles in the Microsoft Knowledge Base:
Q170779 Inconsistent Behavior with Multiple-Field Primary Query

Q160893 Querying Linked SQL Server Tables May Cause Error

Q158933 Error <Database Name> Isn't an Index in This Table

Q178650 Dual Processor Computer Hangs When Running Query

Q191916 No Common Point to Synchronize Replicas After Year 2000

Q191743 "2004: Out of Memory" Error When Running Query

Q191883 Data Changes Are Saved to the Incorrect Record

Q221478 ACC97: QBE Grid and Property Sheet Save Date Values as String

Q225353 ACC97: Error Exporting Access Table to Excel File with Chart

Q225422 ACC97: Query Returns Wrong Records With ODBC vs. Local Tables

Q225351 ACC97: Error Opening Linked Table After SR-2 Update Applied

Additional query words: softlib inf 


Keywords          : kbdta Softlib 
Version           : WINDOWS:97
Platform          : WINDOWS 
Issue type        : kbhowto

Last Reviewed: August 3, 1999