We help IT Professionals succeed at work.

Macro: Security Level problem

Fordraiders
Fordraiders asked
on
Medium Priority
323 Views
Last Modified: 2012-08-14
Access 2003/2000

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


"Any suggestions"  ?

Thanks
fordraiders
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2006

Commented:
hello fordraiders, no long no see

so where is this setting exactly?

Author

Commented:
It is on Macro security level "Med"

Tools/Macro/Security

Author

Commented:
rr
Hope you are well

Commented:
Local DB?  Network db?  Are the databases in a security workgroup?
CERTIFIED EXPERT
Top Expert 2006
Commented:
interesting. When I get odd things I like, I check for corruptness in DB
Have u done the usual decompile, compact/repair etc

Im assuming this is not a read only


Have u tried this setting on another DB? u could try creating a blank one and see what happens

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Commented:
did you recently change to XP?

Author

Commented:
yep !

sorry


Author

Commented:
Local DB?  Network db?  Are the databases in a security workgroup?
yes            no                     no

Author

Commented:
new db wiil not accept low level macro...

Commented:
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?
Commented:
Have you tried creating a self-certificate?
http://office.microsoft.com/en-us/assistance/HP010446111033.aspx
For better or worse, XP OS comes with more stringent default security policy, and administrators often make it impossible to change beyond a certain level.

Author

Commented:
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
CERTIFIED EXPERT
Top Expert 2006

Commented:
tricky one, hope it gets solved. Im off to bed. Flying to the States tomorrow

Commented:
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.


Commented:
Thanks.  Hope you got a solution.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.