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

Access runtime / Windows 7 - how to set a trusted location

Using Microsoft Access 2013 I would want to install the access runtime onto a number of PC's so the users can open and use a database.
How can I add the folder the database will reside in to a trusted location without having the necessary dialog in the access runtime IDE.
Not available in runtime mode(I am testing it with the /runtime flag at present on a development PC).
0
AndyAinscow
Asked:
AndyAinscow
1 Solution
 
Gustav BrockCIOCommented:
The easiest method is to do it the other way around: "install" (=copy) your database file in a location that already is trusted.
That could be %localappdata% (you can paste %localappdata% directly into Windows Explorer).

Here, create a generic folder like your CompanyName.
In this folder, create a folder for your application like MyApp.
In this folder, place a copy of your application and create a shortcut for the user.

/gustav
0
 
PatHartmanCommented:
You may be able to get your desktop support group to distribute the correct registry keys via group policy.  That is what I do for most clients.  Or, you can do it yourself.   Here's an article that gives you a start.
https://social.msdn.microsoft.com/Forums/en-US/a3cb49c3-de8d-41e4-b9ef-77a2f3efeab9/add-ms-access-trusted-location?forum=scripting
0
 
Nick67Commented:
It can be hacked into the registry in whatever fashion suits:

This to permit a network location
[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\Security\Trusted Locations]
"AllowNetworkLocations"=dword:00000001


This for each permitted path, starting at location zero
Local path

[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\Security\Trusted Locations\Location0]
"Path"="DriveLetter:\\foldername\\"
"AllowSubfolders"=dword:00000001
"Description"=""
"Date"="28/03/2013 9:41 AM"


Network path
[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\Security\Trusted Locations\Location1]
"Path"="\\\\server\\share\\"
"AllowSubfolders"=dword:00000001
"Description"=""
"Date"="28/03/2013 9:41 AM"


I got tired of putting them in.
Now a double click does it.
Access 2013 is version 15.0, that's the only change
Access 2007, God help you, is version 12.0
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
AndyAinscowFreelance programmer / ConsultantAuthor Commented:
Thanks for the responses.
I'll get back in a number of days when I have had a chance to study/test them.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
0
 
AndyAinscowFreelance programmer / ConsultantAuthor Commented:
Perfect, thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

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