Tools-macro-security

  • Thread starter Thread starter Pat Hartman
  • Start date Start date
P

Pat Hartman

One of my clients cannot get the change security to low option to stick.
Every time she opens the database, she gets assaulted by meaningless
security messages because she cannot turn them off. Is this being
controlled by the IT department with some registry setting?
 
Hi, Pat.
Is this being controlled by the IT department with some registry setting?
Click to expand...

It's usually a Windows Group Policy setting. She may also have no
permission to alter the Windows Registry, so the Macro Security Level
setting in the Windows Registry doesn't get changed from Medium or High to
Low.

Unless the database has User-Level Security implemented, use
AutomationSecurity in a VB Script file to open the database at the Low Macro
Security Level, regardless of what setting is in the Windows Registry.
Please see the following Web page on former Access MVP Jeff Conrad's Web
site for the VB Script code:

http://www.accessmvp.com/JConrad/accessjunkie/macrosecurity.html

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
Back
Top