Access 2003: Unsafe Expressions are not blocked
Submitted by Dan White on March 16, 2006 - 11:13pm
When you open an Access 2003 database, you get 3 annoying errors.
- Security Warning: Unsafe expressions are not blocked Do you want to block unsafe expressions?
- A Microsoft Jet 4.0 Service Pack warning
- Then another "Security Warning"
To fix this, you can lower your Access security settings manually, or simply use this registry entry to do it for you.
The whole error is:-
To block unsafe expression Microsoft Jet 4.0 Service Pack 8 or later must be installed. To get the latest version of Jet 4.0 go to http://windowsupdate.microsoft.com Microsoft Jet 4.0 Service Pack 8 or later must be installed to block unsafe expressions without affecting common functionality. The latest Microsoft Jet 4.0 service pack is available from Windows Update. To block unsafe expressions, see the About Microsoft Jet Expression Service sandbox mode Help topic, which is available from the link at the bottom of this topic. If the service pack is not applied: Wizards and builders may not start. Switchboards created by Switchboard Manager will fail. The RunCode macro action for calling a Visual Basic for Applications (VBA) procedure will fail. Event handlers that call VBA procedures will fail. VBA procedures called from a property sheet or used in a SQL statement will fail. Filtering on a hyperlink field will fail. Some VBA functions called from a property sheet or SQL statement will fail. More information about this error message online.
The security warning:-
"This file may not be safe if it contains code that was intended to harm your computer. Do you want to open this file or cancel the operation?"