[AccessD] Macros not working in Access 2010

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



More information about the AccessD mailing list