macro security setting disabled in access 2003 on some PCs on network
Posted on 2007-10-09
On all PC's on the network with Access 2003, the Macro security level can be changed through the toolbar except for 1 PC. On that PC, the option to change the macro security via the toolbar is not there? It's not there but greyed out, it's simply not there.
I assume a parameter is set, and I do not know where? The effect this is having is when Access 2003 is used by Visual Basic to print a report, the user is asked each time a macro security question before previewing the report. If the security level is lowered, this security question is not asked. Because the user opens this internally created access database many times each day, the user learns to not read any security warnings; it's the story of crying 'wolf' one too many times.