This article applies only to a Microsoft Access database (.accdb).
Novice: Requires knowledge of the user interface on single-user computers.
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.
To work around this issue, follow these steps:
Close the current database, and then reopen the database.
On the Message Bar, click Options.
In the Microsoft Office Security Options dialog box, select all the options that you want in all sections in the dialog box.