Microsoft KB Archive/829558

From BetaArchive Wiki

Article ID: 829558

Article Last Modified on 7/28/2006



APPLIES TO

  • Microsoft Access 2000 Standard Edition
  • Microsoft Access 2002 Standard Edition
  • Microsoft Office Access 2003




INTRODUCTION

This article contains information about Microsoft Jet 4.0 Database Engine Service Pack 8 (SP8).

Important Jet 4.0 SP8 is not the latest update for the Jet 4.0 Database Engine when you are using Microsoft Windows 2000, Windows XP, or Windows Server 2003. However, the downloads for Jet 4.0 SP8 are still available.

Important You must install the latest Jet update as an important step toward keeping your Jet database in top working condition. For more information about how to obtain the latest Jet update for the Jet Database Engine for other operating systems and for other best practices, click the following article numbers to view the articles in the Microsoft Knowledge Base:

239114 How to obtain the latest service pack for the Microsoft Jet 4.0 Database Engine


303528 How to keep a Jet 4.0 database in top working condition


MORE INFORMATION

How to download the latest Jet 4.0 service pack

There are currently five different versions of the Jet 4.0 Service Pack 8 download that are available:

  • ==== For computers that are running Microsoft Windows 2000 ====


    Important If you are running Windows 2000 Service Pack 4 Update Rollup 1, you have a later version of Jet 4.0 than the version that is included with Jet 4.0 SP8. We recommend that you install the latest service pack for Windows 2000. For more information about how to obtain the latest service pack for Windows 2000, click the following article number to view the article in the Microsoft Knowledge Base:

    260910 How to obtain the latest Windows 2000 service pack

    If you cannot install Windows 2000 Service Pack 4 Update Rollup 1, you can use Windows2000-KB829558-x86-ENU.exe to install Jet 4.0 SP8 on computers that are running Windows 2000.

  • ==== For computers that are running Microsoft Windows XP ====


    Important If you are running Windows XP SP2, you have a later version of Jet 4.0 than the version that is included with Jet 4.0 SP8. We recommend that you install the latest service pack for Windows XP. For more information about how to obtain the latest service pack for Windows XP, click the following article number to view the article in the Microsoft Knowledge Base:

    322389 How to obtain the latest Windows XP service pack

    If you cannot install Windows XP SP2, you can use WindowsXP-KB829558-x86-ENU.exe to install Jet 4.0 SP8 on computers that are running Windows XP.

  • ==== For computers that are running Microsoft Windows Server 2003 ====


    Important If you are running Windows Server 2003 SP1, you have a later version of Jet 4.0 than the version that is included with Jet 4.0 SP8. We recommend that you install the latest service pack for Windows Server 2003. For more information about how to obtain the latest service pack for Windows Server 2003, click the following article number to view the article in the Microsoft Knowledge Base:

    889100 How to obtain the latest service pack for Windows Server 2003

    If you cannot install Windows Server 2003 SP1, you can use WindowsServer2003-KB829558-x86-ENU.exe to install Jet 4.0 SP8 on computers that are running Windows Server 2003.

  • ==== For computers that are running Microsoft Windows 95, Microsoft Windows 98, or Microsoft Windows NT version 4.0 ====

    Use Jet40SP8_9xNT.exe to install Jet 4.0 Service Pack 8 on computers that are running Windows 95, Windows 98, or Windows NT version 4.0.

  • ==== For computers that are running Microsoft Windows Millennium Edition ====

    Use Jet40SP8_WMe.exe to install Jet 4.0 Service Pack 8 on computers that are running Windows Millennium Edition.

Files in Jet 4.0 Service Pack 8

Jet 4.0 Service Pack 8 contains the following files:

   
   File Name          Version          Size
   ------------------------------------------
   Dao360.dll         3.60.8025.0     557,328
   Expsrv.dll         6.0.72.9589     380,957
   Msexch40.dll       4.0.6807.0      512,272
   Msexcl40.dll       4.0.8015.0      303,376
   Msjet40.dll        4.0.8015.0    1,507,600
   Msjetoledb40.dll   4.0.8015.0      348,432
   Msjint40.dll       4.0.6508.0      151,824
   Msjter40.dll       4.0.6508.0       53,520
   Msjtes40.dll       4.0.8015.0      241,936
   Msltus40.dll       4.0.6508.0      213,264
   Mspbde40.dll       4.0.8015.0      356,624
   Msrd2x40.dll       4.0.7328.0      422,160
   Msrd3x40.dll       4.0.6508.0      315,664
   Msrepl40.dll       4.0.8015.0      553,232
   Mstext40.dll       4.0.8015.0      258,320
   Mswdat10.dll       4.0.6508.0      831,760
   Mswstr10.dll       4.0.6508.0      614,672
   Msxbde40.dll       4.0.8025.0      360,720
   Vbajet32.dll       6.0.1.9431       30,749


If you obtain the Jet 4.0 Service Pack 8 download for computers that are running Microsoft Windows 95, Microsoft Windows 98, and Microsoft Windows NT version 4.0, you will also receive the ODBC Desktop Driver Pack drivers. These drivers are included with the Windows 2000 operating system, the Windows XP operating system, and the Windows Server 2003 operating system. The ODBC Desktop Driver Pack drivers includes the following files:

   
   File Name          Version          Size
   ------------------------------------------
   Odbcji32.dll       4.0.6205.0       60,224
   Odbcjt32.dll       4.0.6205.0      285,224
   Oddbse32.dll       4.0.6205.0       27,464
   Odexl32.dll        4.0.6205.0       27,464
   Odfox32.dll        4.0.6205.0       27,464
   Odpdx32.dll        4.0.6205.0       27,464
   Odtext32.dll       4.0.6205.0       27,464

Note The Jet 4.0 Service Pack 8 download for computers that are running Microsoft Windows 95, Microsoft Windows 98, and Microsoft Windows NT version 4.0 does include the ODBC Desktop Driver Pack drivers but does not completely install the drivers. To correctly register the ODBC drivers on your computer, you also have to install Microsoft Data Access Components (MDAC) 2.6 or later. MDAC does not include these driver files, but MDAC does include the core ODBC DLLs that are required to install the drivers and to use the drivers. You must install MDAC after Jet 4.0 Service Pack 8 so that the files are correctly registered.Note The file size may vary slightly. The file size depends on the version of Windows that you are running on your computer. The file version does not change.

If you plan to use Jet Replication Manager with Jet 4.0 Service Pack 8 or later, and you do not have Mstran40.exe version 4.0.6508.0, you must also download and install Jet4repl.exe. For additional information about how to obtain Jet4repl.exe, click the following article number to view the article in the Microsoft Knowledge Base:

321076 Updated version of the Microsoft Jet 4.0 Service Pack 8 replication files is available in the Download Center


For additional information about existing problems that are resolved by Microsoft Jet 4.0 Service Pack 8, click the following article numbers to view the articles in the Microsoft Knowledge Base:

282349 Access quits unexpectedly when linked Oracle table is left inactive


301915 Access causes an error when you export fields with data type single or double to Oracle


Additionally, Jet 4.0 Service Pack 8 fixes the following past problems:

  • Performance problems occurred when certain pass-through queries were run.
  • Microsoft Access unexpectedly quit when you tried to upsize a database where the tables contained triggers.


Note This service pack prevents Access from quitting. This service pack does not make it possible for you to upsize tables with triggers.

  • An "Invalid argument" error message occurred when you tried to create a linked table by using DAO code after the installation of Jet 4.0 Service Pack 7.
  • An access violation occurred when you ran certain queries that used linked Paradox tables.
  • Oracle integer field appeared as double in Access.
  • When you tried to create links to dBase files, you received an access violation or nothing occurred. That is, no link was created, and you did not receive an error message.
  • When you refreshed a linked table, you were prompted to select a DSN although you were still using the same DSN, and all the connection information was correct.



Additional query words: acc2000 acc2002 acc2003 jet update

Keywords: kbdownload kbinfo KB829558