Trust Locations in Access

How to prevent the following warning propping up for users every time they open your access application:

image

When you open the packaged application, you receive the following message:
A potential security concern has been identified.

Warning: It is not possible to determine that this content came from a 
trustworthy source. You should leave this content disabled unless the 
content provides critical functionality and you trust its source.

File path: <path>

This file might contain unsafe content that could harm your computer. 
Do you want to open this file or cancel the operation?

You can add folders to trusted locations from Office Button | Access Options | Trust Center | Trust Center Settings…| Trusted Locations

The entries will be stored in the registry under:

Access 2007

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security\Trusted Locations]

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security\Trusted Locations\Location(n)]

Access 2010

[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\Security\Trusted Locations]

[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\Security\Trusted Locations\Location(n)]

Path: C:\PathtoDB\

AllowSubFolders: 1

Date: DD/MM/YYYY HH:MM

If packaging up an access solution, then place the registry keys in the Package solution wizard.

Advertisements