AndyAinscow
asked on
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.
(I am testing it with the /runtime flag at present on a development PC).
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.
(I am testing it with the /runtime flag at present on a development PC).
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
https://social.msdn.microsoft.com/Forums/en-US/a3cb49c3-de8d-41e4-b9ef-77a2f3efeab9/add-ms-access-trusted-location?forum=scripting
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the responses.
I'll get back in a number of days when I have had a chance to study/test them.
I'll get back in a number of days when I have had a chance to study/test them.
Here's a nice article by MacroShadow that shows the various ways to do this:
https://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/A_10805-Overcome-the-Trust-Center-Nuisance.html
https://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/A_10805-Overcome-the-Trust-Center-Nuisance.html
ASKER
Perfect, thanks.
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