access 2007 trusted location

[Mark Andrews]

Any way to automate the setting of a trusted location. I'm just getting
really sick of walking people thru the steps to set a trusted location.

Every Access 2007 database I develop has code in it.

Maybe a .net EXE program that sets some registry keys (based on directory it
lives in) or something like that?

Even with the videos out there and the 8 or so steps you need to click on I
find the average client
has troubles and I have to walk them through it.

I am not a fan of the trust center.

Mark

 

[John W. Vinson]

Any way to automate the setting of a trusted location.

That would defeat the very purpose of the trust center. If a program could be
executed to "trust itself" without user interaction, every virus writer would
use it.

It's certainly not ideal as it is, but I doubt that Microsoft will do too much
in this direction.

 

[Tony Toews [MVP]]

Any way to automate the setting of a trusted location. I'm just getting
really sick of walking people thru the steps to set a trusted location.

The Auto FE Updater can do that as part of it's operation as well as
many more items such as painless initial user install and keeping the
users FEs up to date. For more info on the free Auto FE Updater
utility see http://www.autofeupdater.com.

You could also update the registry yourself from within your FE. The
first time the user would have to trust the code but after that it
would be ok.

All trusted locations are stored in the registry under:
HKCU\Software\Microsoft\Office\12.0\Access\Security\Trusted
Locations\LocationN
(where N is an integer)

To see what the entries should look like, just add a trusted location
through the Trust Center, then go to the registry to look at the key
and see what it did. Note: you cannot trust a specific file, but only
at the folder level, so you'll want to make sure that you're
installing your app to a folder that contains only your application
and not other stuff.

You can add any key name you want under Trusted Locations\ instead of
using LocationN. Such as Trusted Locations\My App or Trusted
Locations\<generated GUID>

Also see Trusted Locations
http://www.accessribbon.de/en/?Trust_Center:Trusted_Locations

You can just set it in the Registry, as illustrated by Jeff Conrad at
http://accessjunkie.com/faq_33.aspx

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/

 

[Mark Andrews]

Tony,

Thanks for this great answer! The Addpath.exe found at
http://www.accessribbon.de/en/?Trust_Center:Trusted_Locations

is exactly what I wanted (except for the default German message box).

You basically just put this exe in the same location as your front-end and
run it.
Much easier than the 8 steps to add a trusted location (for a novice user).

I'm sure the Auto FE Updater is a great tool, however the little Addpath.exe
serves my needs for now.

For bonus points you would build a little AddPath.exe with a default english
message.
Similar to running this exe with the /LangEN command line argument.

Mark