The changes are not applied until you change the settings in the Access 2007 year setting to reopen the database

Symptoms

Consider the following scenarios. Open the Microsoft Office Access 2007 database. You change the settings in the Trust Center or Access Options dialog box. To reapply the changes, you must open the database. However, the database is not turned on automatically, and you do not receive a prompt to reopen the database. Changes are not applied in this scenario. For example, if you change the macro setting in Access 2007 years from disabling and notifying all macros to disable not notifying all macros, the changes will not be applied until you close and reopen the current database.

Solution

To resolve this issue, close the database manually and reopen the database for changes to take effect.

State

This behavior is by design.

More information

To change the Macro Settings Trust Center, perform the following steps:

1.	Microsoft Office button to access options in turn.
2.	In the Access Options dialog box, click Trust Center in the left pane.
3.	In the right pane, click Trust Center Settings.
4.	In the Trust Center dialog box, click Macro Settings in the left pane.
5.	Click to select the macro settings in the right panel.