Stop disabled mode from blocking a query

If you try to run a query and it does not work, the query might be blocked because Microsoft Office Access is in disabled mode. Disabled mode is a reduced functionality mode that occurs when Access cannot determine whether the content in the database is trusted.

To make the query work, you must enable the database content by indicating that you trust the database content. You can enable database content for a session or specify that a given database is trustworthy and should be enabled by default.

 Note   You can also signify that a database is trustworthy by using a digital signature (digital signature: An electronic, encryption-based, secure stamp of authentication on a macro or document. This signature confirms that the macro or document originated from the signer and has not been altered.). This topic does not discuss digital signatures. For more information, see Show trust by adding a digital signature.

What do you want to do?


Enable database content for a session

To enable database content for a session, you use the Message Bar.

Message Bar

The Message Bar appears just under the Ribbon, and is part of the Microsoft Office Fluent User Interface. If the Message Bar is not visible, you must first show the message bar. In some cases, you will also have to enable the Message Bar. Once the Message Bar is visible and enabled, you can use it to enable database content for a session.

Step 1: Show the Message Bar

If the Message Bar is already visible, you can skip this step.

  • On the Database Tools tab, in the Show/Hide group, select the Message Bar check box.

If the Message Bar check box is disabled, you will have to enable it.

Step 2: Enable the Message Bar

If the Message Bar check box is enabled, you can skip this step.

  • Click the Microsoft Office Button Button image, and then click Access Options.
  • In the left pane of the Access Options dialog box, click Trust Center.
  • In the right pane, under Microsoft Office Access Trust Center, click Trust Center Settings.
  • In the left pane of the Trust Center dialog box, click Message Bar.
  • In the right pane, click Show the Message Bar in all applications when content has been blocked, and then click OK.
  • Close and reopen the database to apply the changed setting.

Step 3: Enable database content for a session

  • In the Message Bar, click Options.
  • In the Microsoft Office Security Options dialog box, click Enable this content, and then click OK.

Top of Page Top of Page

Enable a database by default

To specify that a given database is trustworthy and should be enabled by default, make sure that the database file is located in a trusted location. A trusted location is a folder or file path on your computer or a location on your intranet from which it is considered safe to run code. Default trusted locations include the Templates, AddIns, and Startup folders. You can also specify your own trusted locations.

 Tip   If you want to know the path of the current database, click the Microsoft Office Button, click Manage, and then click Database Properties. The full path of the current database's location is listed on the General tab of the Database Properties dialog box.

Move a database file to a trusted location

  • Open the folder where the database file is currently located, and then copy the database file into the trusted location that you want.

Specify a trusted location

  • In the Message Bar, click Options.
  • At the bottom of the Microsoft Office Security Options dialog box, click Open the Trust Center.
  • In the left pane of the Trust Center dialog box, click Trusted Locations.
  • To add a network location, in the right pane, select the Allow Trusted Locations on my network check box.
  • Click Add new location.
  • In the Microsoft Office Trusted Location dialog box, do one of the following:
    • In the Path box, type the full path of the location that you want to add.
    • Click Browse to browse to the location.
  • To specify that subfolders of the new trusted locations should also be trusted, select the Subfolders of this location are also trusted check box.
  • Optionally, in the Description box, type a description for the trusted location.

Top of Page Top of Page

 
 
Applies to:
Access 2007