You can select the options in all sections of the Microsoft Office Security Options dialog box only one time if the dialog box contains two or more sections in Access 2007

Article translations Article translations
Article ID: 918580 - View products that this article applies to.
This article applies only to a Microsoft Access database (.accdb).

Novice: Requires knowledge of the user interface on single-user computers.
Expand all | Collapse all

SYMPTOMS

Every time that you open a database in Microsoft Office Access 2007, you can select the options in all sections of the Microsoft Office Security Options dialog box only one time.

Note This issue occurs when the Microsoft Office Security Options contains two or more sections.

For example, the Microsoft Office Security Options dialog box contains a VBA Macro section and an Add-In section. Under VBA Macro, you click to select the Enable this content option. However, you do not select any option under Add-In. When you click OK, the default option for the Add-In section is selected.

Note After you click OK in the Microsoft Office Security Options dialog box, the Message Bar disappears. Additionally, the Message Bar check box is unavailable in the Show/Hide group on the Database Tools tab.

WORKAROUND

To work around this issue, follow these steps:
  1. Close the current database, and then reopen the database.
  2. On the Message Bar, click Options.
  3. In the Microsoft Office Security Options dialog box, select all the options that you want in all sections in the dialog box.
  4. Click OK.

Properties

Article ID: 918580 - Last Review: April 6, 2007 - Revision: 1.0
APPLIES TO
  • Microsoft Office Access 2007
Keywords: 
kbtshoot kbexpertisebeginner kbprb KB918580

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com