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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: