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?
awgitAsked:
Who is Participating?
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
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 Access MVP)Database ArchitectCommented:
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
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
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 Access MVP)Database ArchitectCommented:
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 Access MVP)Database ArchitectCommented:
I see .... ok ... good to know.

mx
0
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.

All Courses

From novice to tech pro — start learning today.