You may not have permissions to change the registry as you are logged in.
Try logging in as the administrator. The following is for Access 2003 which
is on this particular machine, but is similar for 2007 (Office/Access 12)
To change the Macro Security setting to low, you can either write some code
or you can make a change to the Windows Registry for each computer that
needs the new security level. The easiest way is to change the Registry
setting. However, many people are uncomfortable altering their Windows
Registry, and making mistakes can cause serious problems, such as the
inability to reboot the computer. Make sure that you back up the Registry
before making changes, and make sure that you also know how to restore the
Registry from a backup before making changes, too.
The Registry keys that need to be changed or added are:
\\HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\SandboxMode
Change the value of this key to 2 if it isn't set there already. (It's the
default.)
Values available for the Sandbox mode:
0 = Sandbox mode is disabled at all times.
1 = Sandbox mode is used for Access applications, but not for non-Access
Applications.
2 = Sandbox mode is used for non-Access applications, but not for Access
Applications. (Default)
3 = Sandbox mode is used at all times.
-------------------
The security level can be changed for either individual users or created for
all users who log onto the computer.
If you need to set the security for an individual user, then you need to
change this key:
\\HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Access\Security\Level
Change the value of this key to 1 for low security. (2 = medium security; 3
= high security)Or for all users on the computer, you need to create this
key:
If you need to set the same security level for all users who log onto the
computer instead, then you need to create this new Registry key:
\\HKEY_LOCAL_MACHINE\Software\Microsoft\Office\11.0\Access\Security\Level
Create the key of type DWORD and set the value to 1 for low security. (2 =
medium security; 3 = high security)
If you'd rather use code to make the change in the security setting for the
current user, then you may copy and paste the code below into a module in
your runtime application so that the user will be able to use the menu to
alter this security setting manually. The subroutine can be called during
the startup of the runtime application or from the click event of a command
button.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
Disclaimer: Any code or opinions are offered here as is. Some of that
code has been well tested for number of years. Some of it is untested
"aircode" typed directly into the post. Some may be code from other
authors. Some of the products recommended have been purchased and
used by the author. Others have been furnished by their manufacturers.
Still others have not been personally tested, but have been
recommended by others whom this author respects.
You can thank the FTC of the USA for making this disclaimer necessary.
