Agee Software, Inc.

Turn Off Macro Security Warnings in Microsoft Access 2013 and newer

Open Access to an existing database or a Blank desktop database.
  1. Click File
  2. Options on bottom left
  3. Trust Center on left
  4. Trust Center Settings on right
  5. Trusted Locations on upper left
  6. Add Trusted Location in center
  7. Browse and browse to folder you want to trust on your c: drive (C:\Work)
  8. OK, OK to save settings.

Screens look similar to Access 2010 below.

Turn Off Macro Security Warnings in Microsoft Access 2010

If you get an error when opening the database for the first time in Access 2003, 2007 or 2010, make sure you have enabled Macros.

1. Start Microsoft Access 2010 from the Start menu.

2. Click File in the upper left corner of the screen.
3. Click Options in the lower left corner of the screen.

4. Click Trust Center on the left side of the screen.

5. Click Trust Center Settings halfway down on the right side of the screen.

6. Click Macro Settings on the left side of the screen.

7. Select the Enable All Macros option and click OK.

Turn Off Macro Security Warnings in Microsoft Access 2007

If you get an error when opening the database for the first time in Access 2003 or 2007, make sure you have enabled Macros.

1. Start Microsoft Access 2007 from the Start menu.
2. Click the Office button in the upper left corner of the screen.
3. Click Access Options in the lower right corner of the screen.

4. Click Trust Center on the left side of the screen.

5. Click Trust Center Settings halfway down on the right side of the screen.

6. Click Macro Settings on the left side of the screen.

7. Select the Enable All Macros option and click OK.