On Sun, 24 Oct 2010 18:25:32 -0700 (PDT), Jan S
<jan.simpson (AT) dpiw (DOT) tas.gov.au> wrote:

<snip>

My point though is don't use Location0, 1, 2, etc. Use something
different in there so you don't overwrite somebody else values who
wasn't as smart as you.

So use
[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\A ccess\Security
\Trusted Locations\My Excellent App]

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/

"Jan S" <jan.simpson (AT) dpiw (DOT) tas.gov.au> skrev i en meddelelse
news:8f150590-218e-4227-9ac0-7f2a08fd44e0 (AT) t20g2000yqa (DOT) googlegroups.com...
On Oct 22, 8:39 am, Tony Toews <tto... (AT) telusplanet (DOT) net> wrote:
Another approach is
1. create a standard folder structure for your application,
2. in your developer version (full version of Access) set the Trusted
Locations using the Access Options>Trust Center>Trust Center
Settings>Trusted Locations.
Add you folder to the trusted locations list.
3. Using REGEDIT export the [HKEY_CURRENT_USER\Software\Microsoft
\Office\12.0\Access\Security] reg settings. This will create a .REG
The REG key will look something like:

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\A ccess\Security]
"VBAWarnings"=dword:00000001

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\A ccess\Security
\Trusted Locations]
"AllowNetworkLocations"=dword:00000001

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\A ccess\Security
\Trusted Locations\Location0]
"Path"="D:\\APPS\\"
"AllowSubfolders"=dword:00000001
"Description"=""
"Date"="17/04/2009 2:00 PM"

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\A ccess\Security
\Trusted Locations\Location2]
"Path"="C:\\Program Files\\Microsoft Office\\Office12\\ACCWIZ\\"
"Description"="Access default location: Wizard Databases"

You can have multiple LOCATIONS, or you can put all you applications
under one folder (D:\APPS) and all subfolders will also be included in
the single entry
4. You can then get the user (or a batch file) to run the .REG file
(just double click)

I use this in a government organisation with a strick lockdown SOE
using runtimes (2007) and it works very well.