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

Posted on 2007-10-17
Last Modified: 2012-05-05
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.
Question by:henkdewolde
    LVL 75

    Expert Comment

    by:DatabaseMX (Joe Anderson - Access MVP)

    Author Comment

    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.
    LVL 75

    Expert Comment

    by:DatabaseMX (Joe Anderson - 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 ?


    Author Comment

    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..
    LVL 75

    Accepted Solution

    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.


    Author Comment

    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\\"

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Suggested Solutions

    Title # Comments Views Activity
    64 bit vba timer module 2 23
    Confirm a record has been added MS Access 4 17
    Subform Link field 13 20
    Access Query concatenation 12 19
    When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
    It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
    Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now