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
LVL 3
FordraidersAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

rockiroadsCommented:
hello fordraiders, no long no see

so where is this setting exactly?
0
FordraidersAuthor Commented:
It is on Macro security level "Med"

Tools/Macro/Security

0
FordraidersAuthor Commented:
rr
Hope you are well
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

jerryb30Commented:
Local DB?  Network db?  Are the databases in a security workgroup?
0
rockiroadsCommented:
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

0
jerryb30Commented:
did you recently change to XP?
0
FordraidersAuthor Commented:
yep !

sorry


0
FordraidersAuthor Commented:
Local DB?  Network db?  Are the databases in a security workgroup?
yes            no                     no
0
FordraidersAuthor Commented:
new db wiil not accept low level macro...
0
jerryb30Commented:
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?
0
jerryb30Commented:
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.

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
FordraidersAuthor 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
0
rockiroadsCommented:
tricky one, hope it gets solved. Im off to bed. Flying to the States tomorrow
0
jerryb30Commented:
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.


0
jerryb30Commented:
Thanks.  Hope you got a solution.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.