You are currently offline, waiting for your internet to reconnect

How to find information about Microsoft Jet 4.0 Service Pack 7

This article was previously published under Q282010
Moderate: Requires basic macro, coding, and interoperability skills.

CONTENTS

INTRODUCTION
This article was written for Microsoft Jet 4.0 Service Pack 7 (SP7). Jet 4.0 Service Pack 7 is not the latest update for the Jet 4.0 Database Engine. The downloads for Jet 4.0 Service Pack 7 are no longer available.

Important You must install the latest Jet update as an important step toward keeping your Jet database in top working condition. For additional information about how to obtain the latest service pack 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
back to the top
MORE INFORMATION

Files in Jet 4.0 Service Pack 7

Jet 4.0 Service Pack 7 contains the following files:
   File Name           Version        Size   -----------------------------------------   Dao360.dll          3.60.6508.2    561,424   Expsrv.dll          6.0.72.9589    380,957   Msexch40.dll        4.0.6807.0     512,272   Msexcl40.dll        4.0.6726.0     319,760   Msjet40.dll         4.0.7328.0     1,507,600   Msjetoledb40.dll    4.0.6807.0     348,432   Msjint40.dll        4.0.6508.0     151,824   Msjter40.dll        4.0.6508.0     53,520   Msjtes40.dll        4.0.7328.0     241,936   Msltus40.dll        4.0.6508.0     213,264   Mspbde40.dll        4.0.6726.0     348,432   Msrd2x40.dll        4.0.7328.0     422,160   Msrd3x40.dll        4.0.6508.0     315,664   Msrepl40.dll        4.0.6726.0     553,232   Mstext40.dll        4.0.7328.0     258,320   Mswdat10.dll        4.0.6508.0     831,760   Mswstr10.dll        4.0.6508.0     614,672   Msxbde40.dll        4.0.6726.0     348,432   Vbajet32.dll        6.0.1.9431     30,749				
Note The file size may vary somewhat. The file size depends on the version of Windows that you are running. The file version does not change.

back to the top
REFERENCES
The following Jet 4.0 replication files were also updated when Jet 4.0 Service Pack 7 was updated:
  • Msreclr40.dll
  • Msrecr40.dll
  • Msrpfs40.dll
  • Mstrai40.exe
  • Mstran40.exe
If you plan to use Microsoft Jet Replication Manager, you must also download and then 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 may be resolved by the updated version of Microsoft Jet, click the following article numbers to view the articles in the Microsoft Knowledge Base:
239471 Jet 4.0 text IISAM allows users to append lines to system files
245676 Records newly inserted into Access database are not immediately available when reselecting
247140 Memory use climbs with multiple recordsets under a single Jet session/connection
248907 Append query on linked tables adds incorrect GUID values
250637 FIX: Jet 4.0 creates incorrect CREATE TABLE statements
251289 New row in linked SQL Server table disappears or appears as a duplicate of last record
254822 Find dialog box or Find methods jump to incorrect record in linked ODBC table
259287 FIX: ODBC error when you use scalar functions to insert timestamp with fractional value
263561 Non-BDE Paradox and dBase ISAM drivers
264766 FIX: #DELETED error when inserting records with CHAR primary key
268264 Run-time error 3433 when you import or export a text file
270704 Scaling errors when you query linked tables
277711 FIX: Updates to linked ODBC tables causes access violation in Msjet40.dll
282604 Microsoft Jet does not pass WHERE clause to ODBC data source
291162 AutoNumber field duplicates previous values after you compact and repair a database
291529 Result of the Mid, the Left, or the Right function in query referring to memo column is incorrect in Access 2002
291541 Memo field characters appear as question marks in Access 2002
291546 Access displays #DELETED when you insert data with the same value into a non-unique key column of a remote table
293199 Slow performance when you open objects in Design view in Access running on Microsoft Windows NT 4.0
293657 #Deleted in a linked table that has a field of type UniqueIdentifier
239482 How to configure Jet 4.0 to prevent unsafe functions from running in Access 2000 and Access 2002
294907 Like "String*" criteria is incorrect on indexed (duplicates OK) fields that have DBCS characters
297355 Error message "Incorrect syntax near ',' (#170)" with a comma as a decimal separator
304084 Access quits when you add data through a query after you upgrade to Jet 4.0 Service Pack 5
304431 You receive a "Cannot include Memo, OLE or Hyperlink Object when you select unique values" error message
304536 FIX: "Object invalid or no longer set" error with Microsoft Jet
311159 FIX: Inefficient use of LIKE clause with Jet OLEDB Provider
319547 Unrelated rows in a subreport or a subform are returned when the Linkmaster property or the Linkchild property uses decimal fields
321850 You cannot open a partial replica file that is created in the Access 2002 format
322063 Data Transformation Services (DTS) reports a successful execution of a package even though the data is not transferred
813696 FIX: Parameter query on linked tables returns no records
814811 BUG: You receive a "Disk or network error" error message when you open Access 2.0 database files in Access 2000 or Access 2002
back to the top
inf jet 4 0 update service pack 7 7.0 sp seven sp-7
Properties

Article ID: 282010 - Last Review: 11/16/2004 19:27:59 - Revision: 15.1

  • Microsoft Access 2000 Standard Edition
  • Microsoft Access 2002 Standard Edition
  • kbjet kbdownload kbinfo kbappcompatibility kbfile kbwinxpsp1fix KB282010
Feedback