Your coach is here to assist
Trust Center in Access 2007, 2010, 2013, and 2016
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.
See: Using Access 2007 Runtime, how can I create a Trusted Location if there's no UI to create it?
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:
Choose a deployment tool for security settings and privacy options in the 2007 Office system
Configure trusted locations and trusted publishers settings in the 2007 Office system
Plan Trusted Locations settings for Office 2010
Downloadable content for the Office 2010 Resource Kit