|
Free Resources from FMS |
|
|
|
|
"Thank you! Thank you! I just finished reading this document, which was part of a link in the recent Buzz newsletter. I have printed it for others to read, especially those skeptical on the powers of Access and its capabilities." - Darren D. |
|
|
|
|
Microsoft
Access Resource Center
How to disable "Sandbox Mode" (startup warning messages) in Access 2003
Provided by: Steve Clark, Project Manager/Developer
After first installation of Microsoft Access 2003, whenever you open a database, Sandbox Mode is enabled letting you know two things:
-
Microsoft Jet 4.0 Service Pack 8 or later must be installed to block unsafe expressions without affecting common functionality.
-
How to block unsafe expressions.
When sandbox mode is enabled, Access evaluates only those expressions in field properties and controls that are safe. An expression is considered safe if it does not use functions or properties that could be exploited by malicious users to access drives, files, or other resources for which they do not have authorization. Examples of this are the Kill or Shell commands.
While this is a nice feature to have, it can be an annoyance for the following reasons:
-
Even after installing Jet service pack 8 or later, you still receive a warning message.
-
There is no way to leave Access 2003 in this mode and turn off the message. In other words, there is no "do not show me this message again" check box or anything else that keeps you from having to click one of the Yes, No, or Help buttons every time Access 2003 is used to launch a database.
-
While major functions that could cause damage are prevented, so are other things that are often necessary like the functions InStrRev, WeekDayName, MonthName, or use of the DBEngine property.
Example
To turn this feature off, you must go into a mode that is less safe according to Microsoft standards and recommendations. Here's how:
- Open MS Access 2003.
- Prior to opening any database, go to Tools, Macro, Security.
- Select the "Low" setting and click OK.
While Microsoft does not recommend this setting to be used, if you have good AntiVirus software on your machine (which everyone should have at this point!), you will probably not encounter security issues.
Another thing you can do to get rid of this message is to digitally sign your Access database project. Any properly digitally signed project will not encounter this message provided you tell MS Access to trust the Certificate created. More information for this can be found in the FAQ listed below
More Information:
- An explanation of Sandbox mode
- A list of functions and properties blocked in Sandbox mode
- For information on Digitally signing, and more
