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\DatabaseN ame.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\Sof tware\Micr osoft\Offi ce\11.0\Ac cess\Secur ity\Truste d Locations, Path,0x00000000,"C:\Direct oryName\Da tabaseName .mdb"
--------------------- end of test.inf file -------------------------- -
Thanks for any help!!
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\DatabaseN
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\Sof
--------------------- end of test.inf file --------------------------
Thanks for any help!!
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
I am trying to create an .inf registry file to stop having security warnings such as the two below.
SecWarnings.PNG
ASKER
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
ASKER
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
"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
And most IT dept's are not going to allow that anyway :-)
mx
ASKER
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
LOL!
;-)
Jeff
ASKER
not far off Jeff
{:<)
{:<)
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