Your coach is here to assist
Trusted Locations and Trusted Documents
When working with Access 2007, 2010, 2013, and/or 2016 it is important to make sure to set the trusted locations.
In 2007 to set create a Trusted Location:
You can add folders to trusted locations from Office Orb > Access Options > Trust Center > Trust Center Settings... > Trusted Locations
In 2010 to set create a trusted location:
You can add folders to trusted locations from File (Backstage) > Access Options > Trust Center > Trust Center Settings... > Trusted Locations
The Trusted Locations are set for each user on a computer. It is not a system-wide setting on a workstation.
Trusted Documents in 2010:
Access 2010 now has the concept of a trusted document. When opening a database you click on the Enable Content button in the Message Bar and the code is trusted. What's new in 2010 is that the code will continue to be trusted on subsequent openings as long as the file is not moved.
Testing to see if in Trusted Location
In Acess 2007/2010 there is a new property CurrentProject.IsTrusted that you can test from a Macro to determine is the VBA code will run.
For a working example, download and open the Northwind 2007 sample database (Click Here) from a non-trusted location to see how this works.
Setting the Trusted Locations when deploying the Access Runtime Version:
If you are using the Microsoft Developer tool to create a deployment package, there is an option in the Wizard to create the registry keys.
There are commercial products available to help you. SageKey (Click Here) is very popular. You will also find a script for the free INNO installed. It can be found in the downloads. See: Inno Installer Script (Like Sagekey)
If you want to use an Automatic Front End Updater then Tony's Auto FE Updater (Click Here) will create "Trusted Locations registry entries so the user no longer sees the 'Access 2007 Security Warning - Certain content in this database has been disabled'"
You can find a free tool called AddPath that is a small EXE file you place in the same folder as the database. By double-clicking on AppPath.exe the folder with subfolders will be added to the trusted locations list. See: Trusted Locations
It is possible to use VBA code to create Trusted Locations. You will find some VBA code you can use in the Utter Access Wiki (Click Here)
For additional information, I recommend the following links: