Working in Access 2010 759
- On the Information About
page, click the Enable Content
button, and then click Advanced Options. - In the Microsoft Office Security Options dialog box, click Trust All From
Publisher, and then click OK.
Note that the Trust All From Publisher option is available only if the database
is digitally signed.
To add the location of a database to the trusted locations list: - Display the Backstage view, and then click Options.
- In the left pane of the Access Options dialog box, click Trust Center, and then
click Trust Center Settings. - In the left pane of the Trust Center, click Trusted Locations.
- On the Trusted Locations page, click Add New Location.
- In the Microsoft Office Trusted Location dialog box, click Browse.
- In the Browse dialog box, browse to the folder containing the current database,
and then click OK. - In the Microsoft Office Trusted Location dialog box, select the Subfolders Of
This Location Are Also Trusted check box if you want to do so, and then click
OK in each of the open dialog boxes.
If you prefer, you can change the way Access handles macros in all databases: - Display the Trust Center, and then in the left pane, click Macro Settings.
- Select the option for the way you want Access to handle macros:
❍ Disable All Macros Without Notification If a database contains macros,
Access disables them and doesn’t display the security warning to give
you the option of enabling them.
❍ Disable All Macros With Notification Access disables all macros and
displays the security warning.
❍ Disable All Macros Except Digitally Signed Macros Access automati-
cally enables digitally signed macros.
❍ Enable All Macros Access enables all macros (not recommended). - Click OK to close the Trust Center, and then click OK to close the Access
Options dialog box.