top
logo


Trust Center in Access 2007 and 2010 PDF Print E-mail
User Rating: / 74
PoorBest 
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.

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 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:

Trusted Locations

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

Utter Access Wiki - VBA Code

 

 

 

 

Sponsored Links


bottom
top

Latest News

Popular


bottom

Powered by Joomla!. Designed by: Free Joomla 1.5 Theme, linux hosting. Valid XHTML and CSS.