Solved

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

Posted on 2010-09-08
10
1,023 Views
Last Modified: 2012-05-10
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!!
0
Comment
Question by:cengen99
  • 5
  • 3
  • 2
10 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 33634337
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



0
 

Author Comment

by:cengen99
ID: 33636919
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
0
 

Author Comment

by:cengen99
ID: 33637156
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
0
 

Author Comment

by:cengen99
ID: 33638918
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 ????
0
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Access MVP)
DatabaseMX (Joe Anderson - Access MVP) earned 100 total points
ID: 33638998
"got word we are going to Access 2007 finally !  "
Which is now almost 4.5 years old and has several issues.  The move s/b to Office 2010.  I fail to see the logic of any company switching to O2007 at this point.  Even the LARGE company I work for, which would normally would stay one release behind ... is moving to O2010 later this year ... and that is a HUGE move.

I'm not sure what your issue is here.  If you want to get rid of those settings, then open up Access >> Menu >> Tools >> Macro >> Security .... Set to Low.

If you are trying to set the security level on the fly, I have yet to see any scheme that will circumvent this, other than those bogus certs or Trusted Location (A2007 >>).

mx
0
Scale it in WD Gold

With up to ten times the workload capacity of desktop drives, WD Gold hard drives employ advanced technology to deliver among the best in reliability, capacity, power efficiency and performance.

 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 400 total points
ID: 33639812
<So my solution should be geared for that, and now perhaps "Trusted Locations" key will work?>

In Access 2007, as long as the DB is in a "Trusted Location" then no registry key should need to be modified.

I am always a bit leery of fixes that require manual manipulation of registry keys...

JeffCoachman
0
 
LVL 75
ID: 33639842
"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
0
 

Author Comment

by:cengen99
ID: 33639926
thanks guys... as for just moving to Access 2007....I am working for an anonymous branch of your government.

0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 33640984
Industrial Military Complex perhaps?

LOL!

;-)

Jeff
0
 

Author Comment

by:cengen99
ID: 33642051
not far off Jeff

{:<)
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You may have a outside contractor who comes in once a week or seasonal to do some work in your office but you only want to give him access to the programs and files he needs and keep privet all other documents and programs, can you do this on a loca…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now