Is there a way to modify the macro security setting programatically?
J Jake Apr 28, 2009 #2 I found my own answer. For others with this isue the setting is at \\HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Access\Security\Level This is a DWORD value set to 1 for low, 2 for medium, and 3 for high. You can do the same thng for all users on the computer by creating a value with the same path but in HKEY_LOCAL_MACHINE instead of HKEY_CURRENT_USER. I fount this at http://www.access.qbuilt.com/html/vba5.html that page is long and this info is near the end
I found my own answer. For others with this isue the setting is at \\HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Access\Security\Level This is a DWORD value set to 1 for low, 2 for medium, and 3 for high. You can do the same thng for all users on the computer by creating a value with the same path but in HKEY_LOCAL_MACHINE instead of HKEY_CURRENT_USER. I fount this at http://www.access.qbuilt.com/html/vba5.html that page is long and this info is near the end
