[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 6526
  • Last Modified:

Can't change Macro security level in Access 2003

Have a user that is opening a database, getting a macro security warning. When they open it, the database locks up. It opens for other users.

The macro security is set to medium, if you try to set it to low, it just goes right back to medium. No policy exists to reset it.

Machine is XP S2 Access 2003

Digitally signing the database is not an option.

Any ideas why I can't change the security level?
0
awgit
Asked:
awgit
  • 4
  • 2
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Possibly a permissions issue for that user?

You can change that key in the Registry:

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Access\Security

Level key ... change the REG_DWORD to 1 = Low.

Try that ... maybe reboot also.

mx
0
 
puppydogbuddyCommented:
My guess: You have to also reset the security level of other members of the office suite (word, excel) that are integrated into your Access application, in order for the warning to go away.

if you set the macro security level to Low in Access and the macro security level is already set to High in Microsoft Word, the security level for Word won't change.  If Microsoft Word or any other member of the Microsoft Office Suite (excel, outlook, internet browser, etc.) is utilized in the Access application, it will cause the securiity warning message until the macro security level is set to low for those objects as well.
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
pDog ... not sure that's the case.  Each app has it's own macro security (insecurity) setting and ... there is an overall Sandbox setting.  My Sandbox setting is Very High, and Access and Excel are Low.  I have not changed the default setting of any other apps.

A colleague of mine has developed a little tool to change these settings on the fly.  So, lately I've spent quite a bit of time on this.

mx

0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
puppydogbuddyCommented:
Hi Mx,
It sounds to me like we are saying pretty much the same thing......that the macro securiity level of any other application that is integrated into the access application (e.g. Word, Excel) also needs to be set to low.

pDog
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Hi pDog ...

Ummm ... that's not really what I am saying - I don't think, lol.

Well ... lets see what the poster has to day ...

mx
0
 
awgitAuthor Commented:
Thanks for the quick response. I had tried the registry key fix for this user and it failed.

However, I had done an office reinstall and didn't think to try it again. Changing the key from 2 to 1 actually worked this time. (Previously it was set to 1 but was still under medium security.)

No other office products are being called on with this database it's all access.

Thanks for your help.
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
I see .... ok ... good to know.

mx
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now