Link to home
Start Free TrialLog in
Avatar of Fordraiders
FordraidersFlag for United States of America

asked on

Macro: Security Level problem

Access 2003/2000

I keep setting my Option Level and  "Low"...
But it keeps changing back to "Med"


"Any suggestions"  ?

Thanks
fordraiders
Avatar of rockiroads
rockiroads
Flag of United States of America image

hello fordraiders, no long no see

so where is this setting exactly?
Avatar of Fordraiders

ASKER

It is on Macro security level "Med"

Tools/Macro/Security

rr
Hope you are well
Local DB?  Network db?  Are the databases in a security workgroup?
SOLUTION
Avatar of rockiroads
rockiroads
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
did you recently change to XP?
yep !

sorry


Local DB?  Network db?  Are the databases in a security workgroup?
yes            no                     no
new db wiil not accept low level macro...
My guess is that the OS security policies have been set to:
a.  Deny access to changing macro security levels
b.  Re-establish this security policy in the event you are somehow allowed to change the macro security level.

You apparently are able to access the Tools, Macro, security options, and presumably apply an update.  Does it switch back when closing and re-opening the database right away, or after a log-off and log-on?
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
You apparently are able to access the Tools, Macro, security options, and presumably apply an update.  Does it switch back when closing and re-opening the database right away, or after a log-off and log-on?

YES, YES
tricky one, hope it gets solved. Im off to bed. Flying to the States tomorrow
odd.  In my experience, when you open a DB and get the Macro security warning message, it lets you click about 2000 yes no or cancel buttons before letting you open a given db, but if you cannot permanently change the macro security level, then the option to do so is grayed out.

As you are obviously finding, the security level, when not working with workgroups, is at system/user level, not database level.


Thanks.  Hope you got a solution.