• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2876
  • Last Modified:

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.
0
henkdewolde
Asked:
henkdewolde
  • 3
  • 3
1 Solution
 
henkdewoldeAuthor Commented:
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.
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
henkdewoldeAuthor Commented:
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..
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Actually, I'm not sure you can allocate trusted locations ... although I bet you can.  I'm saying you can byupass - turn off - the certificate stuff.

I was just  looking at that stuff the other night.

mx
0
 
henkdewoldeAuthor Commented:
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
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now