Darryl Collins
darryl at whittleconsulting.com.au
Mon Feb 3 16:31:38 CST 2014
For some reason a little neuron in the back of my brain is also firing up saying "check the folder permissions". I seem to recall that the users need to have read / write permissions on the folder for this to work. Might be dreaming, but worth a look I guess. Cheers Darryl -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman Sent: Tuesday, 4 February 2014 6:09 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Macros not working in Access 2010 Has to be security. I would double check what you did in Trust Center. The simplest is to add the location of the DB as a trusted location. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Breen Sent: Monday, February 03, 2014 01:18 PM To: Access Developers discussion and problem solving Subject: [AccessD] Macros not working in Access 2010 Hello AccessD Friends, I was knowledgeable on Access 2.0 and even 95 and 97 but I rarely used it nowadays. I joined AccessD in 87/98. I have a client with an Access 2010 db. They are using some DLookups a macro to pull records from the switchboard table. It is not quite the regular switchboard, but it seems to work well. It works on 4/5 machines but on one of the machines the macro does not seem to fire and they get no menu. I have gone to Trust centre and enabled all macros. Any idea why the macro does not fire on one machine but the same mdb file works perfect on another machine on the network. thanks in advance for your advice. Mark Breen -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com