This article provides reference information about the functions and properties that sandbox mode allows and blocks in Microsoft Office Access 2007. Note that Office Access 2007 allows several new functions to run in sandbox mode, including MonthName and StrReverse, and it now blocks several more functions, including Assistance, ExportNavigationPane, and LoadCustomUI. As you proceed, remember that you must trust (enable the content in) the database or place the database in a trusted location for the information in this article to be of use.

For more information about enabling the content in databases or placing databases in a trusted location, see the links in the See Also section.

• Set sandbox mode to run unsafe expressions

• Functions that you can use in sandbox mode

• Functions that cause errors in sandbox mode

• Functions blocked by sandbox mode

• Properties blocked by sandbox mode

Set sandbox mode to run unsafe expressions

When you add an expression to a database, Access runs that expression in an operating environment called sandbox mode. Access does this for databases that were created in either Office Access 2007 or in earlier Access file formats. Access enables sandbox mode by default, and in turn, sandbox mode always disables unsafe expressions, even after you trust a database.

If you trust a database and you want to run an expression that sandbox mode disables, you can run that expression by changing a registry key that disables sandbox mode. Remember that you must first trust a database to follow the steps in this section.

This figure shows the process that you follow when deciding whether to run unsafe expressions.

Caution   Incorrectly editing the registry may severely damage your operating system, requiring you to reinstall it. Microsoft cannot guarantee that problems resulting from editing the registry incorrectly can be resolved. Before editing the registry, back up any valuable data. For the most recent information about using and protecting your computer's registry, see Microsoft Windows Help.

If you are not familiar with the registry or you are not comfortable with changing registry keys yourself, contact someone who is or consider converting the database from the earlier version of Access to the Office Access 2007 file format. Also, you must have administrator permissions on the computer to change the registry values.

Change the registry key

 Important   Following these steps allows unsafe expressions to run in all instances of Access for all users on the computer.

Do one of the following:

• In Windows Vista  
  1. Click the Start button, point to All Programs, click Accessories, and then click Run.
  2. In the Open box, type regedit and then press ENTER.

     The Registry Editor starts.

  3. Expand the HKEY_LOCAL_MACHINE folder and navigate to the following registry key:

     \Software\Microsoft\Office\12.0\Access Connectivity Engine\Engines

  4. In the right pane of the registry editor, under Name, double-click SandboxMode.

     The Edit DWORD Value dialog box appears.

  5. In the Value Data field, change the value from 3 to 2, and then click OK.
  6. Close the Registry Editor.
• In Microsoft Windows XP or Microsoft Windows Server 2003  
  1. On the taskbar, click Start, and then click Run.
  2. In the Open box, type regedit and then press ENTER.

     The Registry Editor starts.

  3. Expand the HKEY_LOCAL_MACHINE folder and navigate to the following registry key:

     \Software\Microsoft\Office\12.0\Access Connectivity Engine\Engines

  4. In the right pane of the registry editor, under Name, double-click SandboxMode.

     The Edit DWORD Value dialog box appears.

  5. In the Value Data field, change the value from 3 to 2, and then click OK.
  6. Close the Registry Editor.

Important  Remember that if you do not first trust the database, Access disables any unsafe expressions regardless of whether you change this registry setting.

You can set the registry value to the following values, with 0 (zero) being the most permissive and 3 being the least permissive.

 Top of Page

Functions that you can use in sandbox mode

The following table lists the functions that you can use in Access database engine queries when sandbox mode is enabled. Any functions that do not appear in the list are not available in sandbox mode.

Use the links in the See Also section for more help for the most commonly used functions.

 Top of Page

Functions that cause errors in sandbox mode

The following Visual Basic for Applications (VBA) functions will cause an error when the functions are called from an expression in an Access database engine query, or when called from an Access property.

Use the links in the See Also section for more help for the most commonly used functions.

 Top of Page

Functions blocked by sandbox mode

Sandbox mode blocks the following Access functions when the functions are called from an expression in a query or from an Access property. An asterisk (*) after the function name indicates a function that is new in Office Access 2007.

Use the links in the See Also section for more help for the most commonly used functions.

 Top of Page

Properties blocked by sandbox mode

In addition to the functions listed in the previous section, sandbox mode also blocks a number of object properties. The following table lists the objects and the blocked property or properties for each object.

Use the links in the See Also section for more help for the most commonly used properties.

 Top of Page