Popular DownloadsDynamic Report based on a Crosstab query (8774)
Boiler Plate Database (8194)
25 Cool Control Tricks (6566)
Report Dialog Examples (5580)
Access Treeview Example - Organization (4705)
Document Links 2 (4374)
Jack MacDonald's How I use Microsoft Access User-Level Security (4036)
|Trust Center in Access 2007 and 2010|
|Written by Boyd Trimmell aka HiTech Coach|
Trust Center in Access 2007 and 2010 Trusted Locations
When working twith Access 2007 and 2010, it is important to make sure to set the trused 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 Trused Locations is 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 determie 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 that 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 Trusrted 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: