Link to home
Start Free TrialLog in
Avatar of cengen99
cengen99

asked on

.inf registry file to set Trusted Location key for MS Access 2003

Hi All,

I have spent a lot of time reading things high and low on the net, and here...  for Access 2003 I have determined that the Macro Security Level needs to be medium, or high in order to set a registry key under the following:

HKEY_CURRENT_USER - Software - Microsoft - Office - 11.0 - Access - Security - Trusted Locations

and from that I have a Key called Path with the datatype of REG_SZ, and the Data value of C:\DirectoryName\DatabaseName.mdb (and the case of the the directoryname and database name match the upper/lowercase of the both the directory and database)

But no luck.... This is what the Test.INF file has in it:

[Version]
Signature=$CHICAGO$

[DefaultInstall]
AddReg=Add.Settings1

[Add.Settings1]
HKCU,HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Access\Security\Trusted Locations, Path,0x00000000,"C:\DirectoryName\DatabaseName.mdb"


--------------------- end of test.inf file ---------------------------

Thanks for any help!!
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

First, "Trusted Locations" are only really applicable for Access 2007 and above.
So I don't know specifically what you were reading...

In Access 2003 you have a "Trust all installed add-ins and templates" setting though...
See here:
http://office.microsoft.com/en-us/office-2003-resource-kit/macro-security-levels-in-office-2003-HA001140307.aspx

<I have determined that the Macro Security Level needs to be medium, or high in order to set a registry key under >

Can you tell us what your ultimate Goal/Issue is here?
(before we start modifying registry settings)

;-)

JeffCoachman



Avatar of cengen99
cengen99

ASKER

Thanks for the reply Jeff.

I am trying to create an .inf registry file to stop having security warnings such as the two below.






SecWarnings.PNG
BTW, I am aware of selfcert.exe, but I am trying to have an .inf file that can be included with this mdb so that as we distribute the file to other users, they can install the inf, create some registry entries, and prevent the security warning screens from appearing.  So I want a simple slam dunk way to get the nag screens to go away, and not drag each user through selfcert or any other involved process
Hold the presses.... Just got word we are going to Access 2007 finally !  So my solution should be geared for that, and now perhaps "Trusted Locations" key will work ????
SOLUTION
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
"I am always a bit leery of fixes that require manual manipulation of registry keys..."

And most IT dept's are not going to allow that anyway :-)

mx
thanks guys... as for just moving to Access 2007....I am working for an anonymous branch of your government.

Industrial Military Complex perhaps?

LOL!

;-)

Jeff
not far off Jeff

{:<)