3.4. Changes to Jet

There have not been any major enhancements to jet, but one or two service packs may need to be installed, depending on when Jet was installed. Those using Access 2003 need to install Service Pack 8. This is so important that it will be repeated.

Also, 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. The Microsoft Knowledge Base article 321076 provides additional information about how to obtain Jet4Repl.exe.

3.4.1. Service Pack 8

For new installations of Access, it is likely that Jet was not already on the system and therefore, Service Pack 8 (SP8) would not be installed already either. In that case, the first thing to do after installing Office and Access is to download and install Office updates and SP8. All developers know that drill by now. SP8 needs to be installed to work with the new security features. The security messages will quickly become irritatingly familiar. So much so that even developers who seldom dealt with security settings on their personal files will learn how to create a digital signature and to digitally sign a file or macro project. This will be briefly explained in the following discussions as well as thoroughly dissected in Chapter 20, "Macro Security."

NOTE

SP8 needs to be installed in order to block unsafe expressions without affecting common functionality. You can learn more about the Sandbox mode in Chapter ...

Get Access 2003 VBA Programmer's Reference now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.