Frequently Asked Question

Frequently asked questions
If you have another subject we should cover, please let us know!

Set up Trusted Location in Microsoft Access Database


Return to FAQs

For security reasons, when you start a Microsoft Access Database which was created on a computer other than your own (a foreign database), Access Database prevents macros and Visual Basic (VB) code from running until you have enabled the database by clicking the ‘ENABLE’ button which appears on the warning notice just below the Access Database ribbon. Microsoft Access Database considers macros and code in a foreign database as unsafe until you have enabled it.

If you obtained the Access Database from a reliable and trusted source, such as GI Business Database Solutions, then Microsoft Access 2007 and later versions of Access Database provide an option to create Trusted Folder Locations. Any Access Database which is operated from a trusted folder location will be considered safe by the Microsoft Access Database program and macros or VB code will automatically be enabled.

The method of setting up Trusted Folders in Microsoft Access 2007, Access 2010 and Access 2013 is similar however there are some slight differences in accessing the options and the format of dialog boxes.

Creating Trusted Folder Locations in Microsoft Access Database

If you obtained the Access Database from a reliable and trusted source, such as GI Business Database Solutions, then Microsoft Access 2007 and later versions of Access Database provide an option to create Trusted Folder Locations. Any Access Database which is operated from a trusted folder location will be considered safe by the Microsoft Access Database program and macros or VB code will automatically be enabled.


  1. Start the Microsoft Access 2007, Microsoft Access 2010 or Microsoft 2013 version that you have installed on your computer.

  2. In Microsoft Access 2007 or Microsoft Access 2010, once the database starts, click the Microsoft Office Button located in the top left hand corner of Access Database program screen. Select the ‘Access Options’ button located at the bottom of the panel.Access 2007-2010 Options
  3. Access Daatabse - Configure Trusted Location
  4. If you are using Microsoft Access 2013 it will be necessary to open and existing database or create a blank database. Once you have done so, click the ‘File’ tab and then select ‘Options’ from the bottom of the list.Microsoft Database Access Option 2013
  5. Trusted locations - 2013 toolbar options
  6. When the Access Options dialog box appears, select ‘Trust Center from the choices provided in the left hand panel, and in the right panel, click on the ‘Trust Centre Settings’ button.
  7. Trusted locations - 2007 toolbar options
  8. In the Trust Center, click the ‘Trusted Locations’ option. To display a list of folder which are already trusted by your Access Database program. Do not remove the default locations for your Access Database install location. If you want to run your Access Database from a network location, you will need to tick the’ Allow trusted locations on my network (not recommended)’ option. After doing so, click the ‘Add New Location’ button

  9. If your Access database has been split into a front-end and back-end configuration, with the database front-end installed locally on your computer, and the Access Database tables file stored on a server or shared folder, then you will need to add a Trusted Locations entry for both the local folder and the network folder share where the tables are stored.

  10. Click the ‘Add New Location’ button. When you check the option ‘Subfolder of this location are also trusted’ you allow Access to also trust any databases which may be located in a subfolder under the folder that you elect to trust. This is handy where you have different Access databases located under the one master folder and you want to trust all of them without adding each folder individually.
  11. Trusted locations - select a folder
  12. Now click the Windows browser button and use the browsers to navigate to the folder that you want to trust and highlight it. With the folder highlighted click the ‘OK’ button.
  13. Trusted locations - Elect to trust sub-folders
  14. Once you return to the ‘Microsoft Office Trusted Locations’ dialog box, if you have you have any Access Database in subfolders that you also want to trust then you must ensure that you tick the ‘‘Subfolder of this location are also trusted’ (if applicable) option. Then click the ‘OK’ button

  15. In the Description box, you have the option to the purpose of the trusted location if you wish, but it is not mandatory.
  16. Trusted locations - select a folder
  17. Click ‘OK’ and then continue to click through the ‘OK’ and ‘Apply’ options to close any open windows or Microsoft Access dialog boxes

  18. If you received an error message whilst attempting to add a trusted location to a network folder this usually indicates that you have forgotten to tick the ‘Subfolders of this location are also trusted’ tick box. See step 7.

If you would like a copy 'Setting up Trusted Location in Microsoft Access Database’ please click Download PDF.

Return to FAQs