Solved

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

Posted on 2014-12-22
6
2,148 Views
Last Modified: 2015-01-06
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
Comment
Question by:AndyAinscow
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 51

Expert Comment

by:Gustav Brock
ID: 40512875
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
 
LVL 38

Expert Comment

by:PatHartman
ID: 40513077
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
 
LVL 26

Accepted Solution

by:
Nick67 earned 500 total points
ID: 40513775
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
Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 
LVL 44

Author Comment

by:AndyAinscow
ID: 40514440
Thanks for the responses.
I'll get back in a number of days when I have had a chance to study/test them.
0
 
LVL 85
ID: 40518347
0
 
LVL 44

Author Closing Comment

by:AndyAinscow
ID: 40535058
Perfect, thanks.
0

Featured Post

Want Experts Exchange at your fingertips?

With Experts Exchange’s latest app release, you can now experience our most recent features, updates, and the same community interface while on-the-go. Download our latest app release at the Android or Apple stores today!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…

622 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