Article ID: 282010
Article Last Modified on 11/16/2004
APPLIES TO
- Microsoft Access 2000 Standard Edition
- Microsoft Access 2002 Standard Edition
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
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
328280 MapPoint and AccessLinks add-in for Excel cause errors to occur and may cause the application to stop responding
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
Additional query words: inf jet 4 0 update service pack 7 7.0 sp seven sp-7
Keywords: kbjet kbdownload kbinfo kbappcompatibility kbfile kbwinxpsp1fix KB282010