ACC2000: Updated Version of Microsoft Jet 4.0 Available in Download Center

The information in this article applies to:
  • Microsoft Access 2000
Moderate: Requires basic macro, coding, and interoperability skills.


SUMMARY

WARNING: This service pack cannot be used with Microsoft Jet 4.0 version 2115.25 that shipped with SQL Server 7.0. Users with this version of Jet must upgrade to SQL Server SP1 or later or MDAC 2.1.2.4202.3 (GA) or later before applying this service pack. Failure to do so will likely break your database products and could cause data corruption.

Users with Microsoft Jet 4.0 version 2521.09 or version 2808.00 are advised to upgrade to MDAC 2.1.2.4202.3 (GA) or later before applying this service pack to ensure consistency of the database components on their computers. For more information about the latest version of MDAC and to download it, please visit the following Microsoft Web site:

http://www.microsoft.com/data
IMPORTANT: If you are running Microsoft Windows 2000, do not apply the update described in this article. Windows 2000 includes a new feature called Windows File Protection (WFP) that prevents the replacement of certain system files. Some files contained in this update are protected system files. If you install this update, WFP will restore these files to the original version that shipped with Windows 2000.

For additional information about Windows File Protection, click the article number below to view the article in the Microsoft Knowledge Base:
Q222193 Description of the Windows 2000 Windows File Protection Feature
The Jet40SP4.exe file contains an update of several .dll files that are included with Microsoft Access 2000, Microsoft Office 2000 Developer, Microsoft Visual Basic version 6.0 or later, and other products that incorporate Microsoft Jet database engine 4.x. Version 4.0 SP4 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 is a stand-alone utility that allows you to compact databases created with Microsoft Jet database engine 4.x. This utility may be used in conjunction with Microsoft Jet database engine 4.0 for recovering corrupted databases. Although it is possible to use the Microsoft Access Compact utility or the CompactDatabase method with Microsoft Jet database engine 4.0, 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 2000
  • Microsoft Access 2000
  • Microsoft Visual Basic 6.0
  • A Microsoft Office Developer 2000 run-time application that includes the run-time version of Microsoft Access 2000
  • A Microsoft Visual Basic 6.0 run-time application that includes Microsoft Jet database engine 4.0
The following file is available for download from the Microsoft Download Center. Click the file name below to download the file:
jet40sp4.exe
For more information about how to download files from the Microsoft Download Center, please visit the Download Center at the following Web address
http://www.microsoft.com/downloads/search.asp
and then click How to use the Microsoft Download Center.

Microsoft used the most current virus detection software available on the date of posting to scan this file for viruses. Once posted, the file is housed on secure servers that prevent any unauthorized changes to the file.



NOTE: Jet40sp4.exe was updated on April 26, 2000.

The current release of Jet 4.0 SP4 contains the following files: 
   File Name          Version        Size
   -----------------------------------------
   dao360.dll         3.60.3714.5    557,328
   JETCOMP.exe        4.0.1532.0     65,536
   msexcl40.dll       4.0.3714.0     323,856
   msjet40.dll        4.0.3714.7     1,499,408
   msjetoledb40.dll   4.0.3714.0     348,432
   msjtes40.dll       4.0.3714.5     241,936
   msltus40.dll       4.0.3714.0     213,264
   msrd3x40.dll       4.0.3714.0     315,664
   msrepl40.dll       4.0.3714.0     553,232
   msrpfs40.dll       4.0.3714.0     74,000
   mstext40.dll       4.0.3714.5     250,128
   mstrai40.exe       4.0.3714.0     37,136
   mstran40.exe       4.0.3714.0     45,328

How to Install the Jet 4.0 Update

Jet40SP4.exe is a self expanding archive that expands the files into the appropriate folder. To completely install the Jet 4.0 Update, follow these steps:
  1. Ensure that you have installed MDAC 2.1.2.4202.3 (GA) or later before updating the Jet 4.0 database engine. See the warning at the beginning of this article for information about which versions of Jet can be updated.

  2. Download Jet40SP4.exe to any folder on your hard disk.

  3. In Windows Explorer, double-click the Jet40SP4.exe file to begin the installation process.

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


MORE INFORMATION

There were two previous updates to Jet 4.0. The first release of Jet 4.0 SP3 contained the following files: 

   File Name          Version       Size
   ------------------------------------------
   msjet40.dll        4.00.2927.4   1,495,312
   msrepl40.dll       4.00.2927.2   557,056 
   dao360.dll         3.60.2927.4   557,328 
   Jetcomp.exe        4.0.1532.0    65,536 
   msjetoledb40.dll   4.00.2927.2   348,342
   msjtes40.dll       4.00.2927.6   237,840
   msrd3x40.dll       4.00.2927.4   315,664
   mstext40.dll       4.00.2927.6   241,936
The second release, on October 11, 1999, of Jet 4.0 SP3 contained the following files: 
   File Name          Version        Size
   -----------------------------------------
   dao360.dll         03.60.2927.4   557,328
   JETCOMP.exe        4.0.1532.0     65,536
   msexcl40.dll       4.00.2927.9    323,856
   msjet40.dll        4.00.2927.4    1,495,312
   msjetoledb40.dll   4.00.2927.2    348,432
   msjtes40.dll       4.00.2927.6    237,840
   msltus40.dll       4.00.2927.9    209,168
   msrd3x40.dll       4.00.2927.4    315,664
   msrepl40.dll       4.00.2927.2    553,232
   mstext40.dll       4.00.2927.11   250,128
For additional information about existing problems that may be resolved by the updated version of Microsoft Jet, click the article numbers below to view the articles in the Microsoft Knowledge Base:
Q239482 ACC2000: Jet 4.0 Expression Can Execute Unsafe Visual Basic for Applications Functions
Q239471 Jet 4.0 Text IISAM Allows Users to Append Lines to System Files

Additional query words: inf

Keywords : kbdta
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbinfo
Technology : kbvcSearch


Last Reviewed: May 17, 2000
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.

Article ID: Q239114

Last Reviewed:
May 17, 2000

Provided by Microsoft Product Support Services.