Andrew Lacey
andy at minstersystems.co.uk
Thu Jun 7 07:52:16 CDT 2012
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: > > > >> Ok so you deliver a working MDB and the first thing the user sees when > >> they open > >> it is a series of popups warning about stopping running macros and then > >> allowing > >> them to run this one. The Medium-level Access macro security stuff. All > >> very > >> messy. Site won't permit setting Low security because of risk from other > >> Access > >> apps. Reading the MS literature it looks to me as if the easiest solution > >> is to > >> create a trusted location but as I plan to roll this out using Access 2010 > >> Runtime I suspect the end-user pc's won't have the tools tto cereate a > >> trustred > >> location (or am I wrong?). What do you guys do? Am looking for simplest > >> solution. > >> > >> Cheers > >> > >> Andy > >> > > > > -- > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/**mailman/listinfo/accessd<http://databaseadvisors.com/mailman/listinfo/accessd> > > Website: http://www.databaseadvisors.**com<http://www.databaseadvisors.com> > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com