[AccessD] Help with Macro Security Level, Trusted Locations, Signatures et al

jwcolby jwcolby at colbyconsulting.com
Thu Jun 7 08:14:13 CDT 2012


I use the following.  I place it in my Dev directory under which are all of my access projects and 
run it.  Everything in that location and below are suddenly trusted.  The only problem is that it is 
written in German but just click OK and you are done.

Google AddPath.exe

http://alexeilebedev.blogspot.com/2007/10/addpathexe.html
http://www.pcreview.co.uk/forums/access-2007-trusted-location-t3994021.html

John W. Colby
Colby Consulting

Reality is what refuses to go away
when you do not believe in it

On 6/7/2012 8:52 AM, Andrew Lacey wrote:
> Thanks Jim, don't think I've a problem using trusted locations, as long as I can
> create one.
>
> JC, do you know what the registry update is? I've found this on-line:
>
> [HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\Security]
> "VBAWarnings"=dword:00000001
> [HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\Security\Trusted
> Locations\Location3]
> "Path"="C:\Database"
> "Description"=""
> "Date"="6/7/201209 4:00 PM"
>
> but when I run the .Reg file I get the message saying "Are you sure you want to
> update the registry" but then it can't be imported because it's not a registry
> script. Any ideas?
>
> Andy
>
>
>
> On 07 June 2012 at 13:40 Jim Hewson<jm.hwsn at gmail.com>  wrote:
>
>> I am a contractor for a government agency.  They have implemented group
>> policy to disable macros and trusted locations.  I've tried a registry hack
>> and all sorts of things to by-pass the messages that come up to no avail.
>> The best that I can do is to train the user what the messages mean and what
>> to do.  I've also learned that since I'm using Access 2007, if I change the
>> extension to ACCDR (runtime) only one message appears.
>> Jim
>> On Thu, Jun 7, 2012 at 5:46 AM, jwcolby<jwcolby at colbyconsulting.com>  wrote:
>>
>>> I use a third party app which creates a trusted location.  However it does
>>> so with registry writes which may not work in your case.
>>>
>>> John W. Colby
>>> Colby Consulting
>>>
>>> Reality is what refuses to go away
>>> when you do not believe in it
>>>
>>> On 6/7/2012 4:36 AM, Andrew Lacey wrote:



More information about the AccessD mailing list