Microsoft KB Archive/918580

= 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 ID: 918580

Article Last Modified on 4/6/2007

-

APPLIES TO


 * Microsoft Office 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.

Additional query words: AC2007 ACC2007 Access2007

Keywords: kbtshoot kbexpertisebeginner kbprb KB918580

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.