In order for the ODBC drivers to be correctly registered on your computer, you also need to install Microsoft Data Access Components (MDAC) 2.6 or later. MDAC does not include these driver files, but it includes the core ODBC DLLs that are required to install and use the drivers. You must install MDAC after Jet 4.0 SP8 for it to correctly register these files.
If you plan to use Jet Replication Manager with Jet 4.0 SP7 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 OFFXPDEV: Updated Version of the Microsoft Jet 4.0 SP7 Replication Files Is Available in the Download Center
For additional information about existing problems that are resolved by Microsoft Jet 4.0 SP8, click the following article numbers to view the articles in the Microsoft Knowledge Base:
282349 ACC2002: 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
Microsoft Jet 4.0 SP8 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.
Prevents Access from quitting. It does not permit you to upsize tables with triggers.
Invalid argument error message occurred when you tried to create a linked table by using DAO code after the installation of Jet 4.0 SP7.
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 even though you were still using the same DSN, and all the connection information was correct.
There are currently four different versions of the SP8 download that are available:
Updated On: 12.12.04