Access 2016 Runtime Trusted Locations Setting

Bob Collison
Bob Collison used Ask the Experts™
on
Hi Experts.\,

I have Office 2010 Pro installed which includes Access.  i.e. Office Version 14.0

I have just installed anapplication developed in Access 2016.

When I tried to run it, it required Access 2016 so I installed Access 2016 Runtime.  i.e. Office Vesion 16.0.

When  I try to run the Access 2016 App it is displaying the Security Warning.  Since Access 2016 Runtime doesn't have an option to specify Trusted Locations I am forced to deal with the Security Warning each time I start the App.

How can I eliminate the Security Warning for the Access 2016 App since setting Trusted Locations is based on the Office Version installed.?

Thanks,
Bob C.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Distinguished Expert 2018

Commented:
Likely, the runtime relies on the same registry locations for setting Trusted Locations as office does. Since it's documented, you may look those up and set these exceptions manually.
Bob CollisonSystem Architect

Author

Commented:
Hi McKnife,

I was able to determine - as indicated in my question - that the Runtime does use the same location as the Office version but I don't know how to set the exceptions manually.  I did take a look at a previous EE solution but it doesn't explain how to manually do it - just provides some code to do it which looks quite complicated.

Thanks,
Bob C.
Software & Systems Engineer
Commented:
For Access 2016 the setting are :


[HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Access\Security\Trusted Locations]

[HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Access\Security\Trusted Locations\Location(n)]

But you can set it easily with this tool : https://www.accessribbon.de/en/?Trust_Center:Trusted_Locations
Bob CollisonSystem Architect

Author

Commented:
Hi Experts,

Thanks for the great information.

Bob C.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial