asked on

How to configure a trusted location when only Access 2007 Runtime is installed

I need to configure an Access trusted location when distributing an Access 2007 application in order to supress security warnings. I would like to know how to add/update the list of trusted locations if only the Access 2007 runtime environment is installed on the end-user's machine.

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

Some recent discussions on the subject:

https://www.experts-exchange.com/questions/22720852/Serial-protection-of-MDE-with-cross-reference-to-Company-name-that-they-need-to-type-in.html

https://www.experts-exchange.com/questions/22488469/Avoiding-security-warning-by-adding-digital-signatrues.html

https://www.experts-exchange.com/questions/22741676/How-do-I-prevent-the-pop-up-security-box-in-Access-11-when-the-database-opens.html

mx

henkdewolde

ASKER

Thanks for the links, however doesn't seem to answer my question.

FYI we have been disappointed with the code signing procedures, in particular technical support, end-user interaction and finally behavior at expiry (security warnings will appear again).

Therefore the trusted locations are really the answer - our customers know us and with a proper procedure they can trust our application and not be bothered any further.

So the question remains: if only Access Runtime is installed, how can an end-user designate a trusted location?

Thanks for the help.

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

OK ... The only way I can see that you can do that is to change that setting in the Registry for Access. Each Office 2007 has two keys associated with this. Unfortunately, my A2007 machine is not with me at the moment, or I would tell you the keys.

Do you feel you can or are willing to ... modify these keys with your install program ?

mx

henkdewolde

ASKER

Thanks for this information. I did not realize that it would be possible to add trusted locations through the registry. I can followup from here myself. How can I allocate the points? This is my first question ever round here..

ASKER CERTIFIED SOLUTION

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

henkdewolde

ASKER

Note that I added a trusted location using Access and found the following keys in the registry:

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security\Trusted Locations\Location19620920]
"Path"="C:\\My Trusted Location\\My Trusted Location\\"
"Description"=""
"Date"=""

After exporting the key and deleting the trusted location I was able to reload using regedit; it shows up correctly in the Access trusted locations.

Seems ok, so the question can be closed.
Thanks