• Melbourne
  • Australia

Phone: +61 03 9410 9815

Setting up Trusted Location in Microsoft Access Database

Return to FAQs

For security reasons, every time that you start a Microsoft Access Database which was created on a computer other than your own (a foreign database), Access Database will prevent any macros or Visual Basic (VB) code from 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 will consider all 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

  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. 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
  4. 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. Access Options dialog box
  5. 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. Access Database 2007  Add Trusted Locations
  6. 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.
  7. 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. Add New Location dialog box
  8. 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. browse dialog box
  9. 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  Microsoft Office Trusted Location dialog box
  10. In the Description box, you have the option to the purpose of the trusted location if you wish, but it is not mandatory.
  11. Click ‘OK’ and then continue to click through the ‘OK’ and ‘Apply’ options to close any open windows or Microsoft Access dialog boxes
  12. 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 of ‘Setting up Trusted Location in Microsoft Access Database’ simply click Download PDF

Return to FAQs

Search

Subscribe to Newsletter

Get the latest GI Business Database Solution News and be amongst the first to know when we release new or updated Access Database business sample.

Obligation Free Advice

Need a custom Access database for your business but don’t know where to start?

Send us the details and well get back to you to discuss your options. No obligation and it’s free. Contact Us

Database Download… Free!

Why not download and try one of the many Microsoft Access databases available in our download section. Most are FREE to keep and use as long as you like.


Error: Please enter a valid email address

Error: Invalid email

Error: Please enter your first name

Error: Please enter your last name

Error: Please enter a username

Error: Please enter a password

Error: Please confirm your password

Error: Password and password confirmation do not match