How to set the Trusted Location Registry Entry in VBA?

I had this question after viewing Setting Trusted Locations.

How can I set the Trusted Location Registry Entry in VBA for Office 13.0 ie:
HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\Security\Trusted Locations\My program Folder

My program Folder is C:\FFNC

I want to run a once-only, simple accdb to add the registry setting.

I'm assuming I can't use SaveSetting.  If I can, what would the syntax be?

Thanks in advance.

Clive BeatonAccess DeveloperAsked:
Who is Participating?
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You can't use SaveSetting, because that saves to a specific Registry location. Gunter Avenis has created a few helper apps that can do this for you easily:

Toward the bottom of the page are samples of how to use the apps
Clive BeatonAccess DeveloperAuthor Commented:
Thanks very much.  I appreciate your explanation on why I can't use SaveSetting.

Compliments to Gunther Avenis,

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.

All Courses

From novice to tech pro — start learning today.