Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/172733

From BetaArchive Wiki

Article ID: 172733

Article Last Modified on 3/29/2006


  • Microsoft Access 97 Standard Edition

This article was previously published under Q172733


Warning To apply this service pack successfully, you need to have Microsoft Jet version 3.51.0623 or later installed on your computer. If your computer has an earlier version of Jet than this, you must upgrade your computer to Microsoft Office 97 Service Release 2 (SR-2). You can get information about Office 97 SR-2 and download the Office 97 SR-2 update from Tools on the Web at the following address:

Failure to update your computer to the proper version of Jet may result in damage to your database products or may result in data corruption.

Note Jet35sp3.exe (Microsoft Jet 3.5 Service Pack 3) replaces Jet35sp2.exe (Microsoft Jet 3.5 Service Pack 2), which is referenced on the Microsoft Office 97 SR-2 pages on Tools on the Web ( Service Pack 2 and Service Pack 3 are both Year 2000-compliant; however, Service Pack 3 also includes additional security updates that are not available in Service Pack 2. If you have not yet installed Service Pack 2 or Service Pack 3, you should install Service Pack 3.

The Jet35sp3.exe file contains an update of several .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 Jet35sp3.exe, was updated on September 1, 1998. You can now use Jetcomp.exe on secured databases and databases that have a database password. Jet35sp3.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:

190463 What are MDAC, DA SDK, ODBC, OLE DB, ADO, RDS, and 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:

  • 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

The following file is available for download from the Microsoft Download Center:

For more 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 prevent any unauthorized changes to the file.

Note Jet35sp3.exe was updated on October 11, 1999. If you previously installed this update and would like to use the stricter security control provided in the updated Mstext35.dll, run the installed Mstext35.reg file. To run the Mstext35.reg file, locate the file on your system, and then double-click it.

The current release of Jet 3.5 SP3 contains the following files:

File name File version File size
Advpack.dll 4.71.1015.0 74,960
Jetcomp.exe 1.0.715.0 39,424
Msexcl35.dll 3.51.3227.2 252,688
Msjet35.dll 3.51.3328.0 1,050,896
Msjt4jlt.dll 3.52.3328.0 1,238,288
Msltus35.dll 3.51.3227.2 168,720
Mspdox35.dll 3.51.3007.0 250,128
Msrepl35.dll 3.51.3225.0 415,504
Msrpfs35.dll 3.51.2826.0 44,304
Mstext35.dll 3.51.3330.0 166,672
W95inf16.dll 4.71.704.0 2,272
W95inf32.dll 4,608

The Jet35SP3.doc file is also included. This file explains the installation instructions for the update and additional information about the improved Compact utility.

How to determine the current service pack level for Jet 3.5

Use the following steps to determine the Jet 3.5 service pack level that is currently installed on your computer.
Note Because there are several versions of Microsoft Windows, the following steps may be different on your computer. If they are, see your product documentation to complete these steps.

  1. On the Start menu, click Search.
  2. In the Search Results pane under Search Companion, click All files and folders.
  3. In the All or part of the file name box, type msjet35.dll, and then click Search.
  4. In the list of files, right-click the msjet35.dll file located in the Windows\System32 (or Windows\System) folder, and then click Properties.
  5. Click the Version tab, and then use the following table to determine the current Jet 4.0 service pack level:
Msjet35.dll Version Jet 3.5 Service Pack Level
3.51.2723.0 Service Pack 2 (SP2)
3.51.3203.0 Service Pack 3 (SP3)
3.51.3328.0 Service Pack 3 (SP3) with enhanced security

How to install the Jet 3.5 Update

Jet35SP3.exe is a self expanding archive that will expand the DLL files into the Windows\System folder. To completely install the Jet 3.5 Update, follow these steps:

  1. Make sure that you have Service Release 2 of Access or of Office 97. To determine whether you have Service Release 2 of Access or of Office 97, follow these steps:
    1. Start Microsoft Access 97, and then click Cancel when you are prompted to open a database.
    2. On the Help menu, click About Microsoft Access.

      The Service Release version is listed directly below the product name and above the copyright information. If this line says SR-1 or is missing completely, you must obtain the Service Release 2 update from Tools on the Web that is described in the "Summary" section of this article.
  2. Download Jet35SP3.exe to any folder on your hard disk.
  3. In Windows Explorer, double-click Jet35SP3.exe.

You may need to restart your computer for the changes to take effect.


The first release of Jet 3.5 SP3 contained the following files:

File name File version File size
Msjet35.dll 3.51.3203.0 1,050,384
Msrepl35.dll 3.51.3007.1 415,504
Msjt4jlt.dll 3.52.3203.0 1,238,800
Msexcl35.dll 3.51.2723.2 250,640
Mspdox35.dll 3.51.3007.0 250,128
Msrpfs35.dll 3.51.2826.0 44,304
Mstext35.dll 3.51.3203.0 166,672
Jetcomp.exe 1.0.1526.0 39,424

The Jet35SP3.doc file is also included. This file explains the installation instructions for the update and additional information about the improved Compact utility.

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:

239105 Text IISAM allows users to Append lines to system files

239104 Jet Expression can execute query with unsafe Visual Basic for applications functions

239106 Error message running query when criteria is only question marks

235960 "ORDER BY clause is not valid..." error with linked Table

170779 Inconsistent behavior with multiple-field primary key

160893 Querying linked SQL Server tables may cause error

158933 Error message: "<Database Name> isn't an index in this table"

178650 Dual processor computer hangs when running query

191916 ACC97: No common point to synchronize replicas after year 2000

191743 ACC97: "2004: Out of Memory" error when running query

191883 ACC: Data changes are saved to the incorrect record

221478 ACC97: QBE grid and property sheet save date values as string

225353 ACC97: Error exporting access table or query to existing Excel file with chart sheet

225422 ACC97: Outer join returns wrong records with ODBC tables vs. local tables

225351 ACC97: "File already in use" error opening linked table on read-only source after SR-2 Update applied

227259 ACC97: "Ambiguous column naming in select list" in an outer join with linked ORACLE table

227413 ACC97: "ODBC Call Failed" error sorting on field in a linked DB2 table

Additional query words: inf

Keywords: kbexpertiseadvanced kbinfo kbdownload kbhowto KB172733