You are currently offline, waiting for your internet to reconnect

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

This article applies only to a Microsoft Access database (.accdb).

Novice: Requires knowledge of the user interface on single-user computers.
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.
AC2007 ACC2007 Access2007
Properties

Article ID: 918580 - Last Review: 04/06/2007 00:20:08 - Revision: 1.0

  • Microsoft Office Access 2007
  • kbtshoot kbexpertisebeginner kbprb KB918580
Feedback