Add a trusted location with Access 2007 Runtime

[mnorman@rooksales.co]

This works on Windows XP and Windows 2003 Server for Access 2007 Runtime SP2. Tested on 9/25/2009.

Copy and paste the following into a text file and change the file extension to .reg. Then simply run the file to import the registry keys into the Windows registry. That's it!

HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security]
"VBAWarnings"=dword:00000001
[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security\Trusted Locations]
"AllowNetworkLocations"=dword:00000001
[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security\Trusted Locations\Location0]
"Path"="\\\\termserv\\users\\dispatch\\DRIVER SCORECARD\\"
"Description"=""
"Date"="9/24/2009 4:19 PM"
[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security\Trusted Locations\Location2]
"Path"="C:\\Program Files\\Microsoft Office\\Office12\\ACCWIZ\\"
"Description"="Access default location: Wizard Databases"

Martin Norman
A Genie in a Bottle computers

 

[DataMinerHome]

I just create the registry settings once for each new user, when I am setting them up. So this isn't really an issue for me. Seems extreme to do it at each login, as you only need to do it once for each PC or server....