All Access fixes are strongly recommended to apply to your systems. If appropriate also visit Microsoft Access Developers Edition Service Packs, Release, Patches and Updates. Note that the Developers Edition Service Packs are not part of Microsoft Office Update.
Weird problems and corruption can happen if different Service Releases of Microsoft Access/Office or Service Packs of Jet are installed at different PCs.. For some sample code to verify the version numbers of key DLLs when you start your app visit Verify Appropriate Jet Service Pack is installed.
Microsoft Office Update: Office 2000 and newer are now part of the Office Update strategy which will automatically update your system. You can still download the updates and patches individually especially if you want to minimize Internet traffic.
The Developers Version has had a different name and abbreviation in just about each version of Access. It's basic function, as far as this document is concerned, is to give you a means of distributing a "runtime" version of Access along with your application royalty free. If you're not sure if you have it installed then you almost certainly don't.
Data Access and Storage Developer Home - Product and Update Downloads This
page lists downloads for Microsoft data access technologies, including ADO.NET,
Microsoft Data Access Components (MDAC) and the Microsoft SQL Server 2000
Desktop Engine (MSDE 2000).
I'm not overly familiar with MDAC so no comments other than the above.
|Access is the Graphical User Interface that allows you to work with
tables, queries, etc. Jet is the database storage system.
They each have their own set of patches. Most of the time the
difference between Jet and Access isn't that important. However now is that
Access 2000 and newer use Jet 4.0 which is at SP 8. (There is a newer version available as part of a security patch. However it doesn't have a Jet version.) Thus if you have multiple versions of Access 2000 and newer installed you only need to concern yourself with Jet 4.0.
Access 97 uses Jet 3.5 which is now at SP 3. Although with the Jet 3.5 SP3 it's actually Jet 3.51 in the references window. Access 95 uses Jet 3.0 and I sincerely hope you are not using it. Access 2.0 uses Jet 2.5. Access 1.0/1.1 I forget now and I'm not installing it to find out either.
MS04-014: Vulnerability in the Microsoft Jet Database Engine could permit code execution - 837001 Note that while this updates Jet 4.0 this does not have a Jet SP version number.
How To: Obtain
the Latest Service Pack for the Microsoft Jet 4.0 Database Engine - 239114
or Information About Jet 4.0 Service Pack 8 - 829558
Updated version of the Microsoft Jet 4.0 Service Pack 8 replication files is available in the Download Center - 321076
You should not be at Windows 2000 SP2 as SP3 has a bunch of security and other fixes in it. Therefore this note should be irrelevant. There is a problem with Windows 2000 SP2. Q304084 - Access Quits When You Add Data Through a Query After You Upgrade to Jet 4.0 Service Pack 5. Jet 4.0 SP 6 (and newer) is out and will resolve this problem. While I didn't check for each individual file Win2K SP3 and Win XP SP1 have the Jet updates also contained in Jet 4.0 SP6.
Jet 4.0 SP4 and SP5 are particularly troublesome. Update them as soon as possible. For example ACC2000: AutoNumber Field Duplicates Previous Values After You Compact and Repair a Database - 257408.
Updated Version of Microsoft Jet 3.5 (Jet35SP3) Note that these are newer than the below SR-1 or SR-2 fixes. You must previously installed Access/Office 97 SR-2.
of Office 2003 Service Pack 1
Issues that are fixed in Access 2003 by Office 2003 Service Pack 1
Office 2003 Service Pack 1 (Download as a file)
Access XP (sometimes known as Access 2002)
Office XP Developers Edition
The below Runtime Updates update the Access runtime on the client workstations to the same level as corresponding Office XP Service Pack. These do not update the runtime you, the developer, create on your own system. These updates also do not update Jet. The Microsoft Office Update did identify these as updates to be required.
These update your developers version but only with developer patches. And not the patches for the files you distribute. In other words the runtime creates the runtime package using the files from the original Office install without any patches.
Also the Office Update website will not check for updates to the Developers portion of Office.
Microsoft Office 2000 Developer
Access 97 (occasionally known as Access 8.0)
Access 7.0 aka Access 95
[ Access | Main ]
Auto FE Updater distribute new and updated Front End databases to your users with several mouse clicks.
Granite Fleet Manager - the best designed fleet maintenance tracking and management system available