Jim Dettman
jimdettman at verizon.net
Thu Jun 7 08:03:37 CDT 2012
The simplest is adding a trusted location. The other option is to digitally sign your app: http://office.microsoft.com/en-us/access-help/show-trust-by-adding-a-digital -signature-HA010342008.aspx I've always gone the registry route when needed. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andrew Lacey Sent: Thursday, June 07, 2012 04:36 AM To: AccessD at databaseadvisors.com Subject: [AccessD] Help with Macro Security Level, Trusted Locations,Signatures et al 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 Website: http://www.databaseadvisors.com