Hi Norbert,
Thanks your feedback. If I understand correctly that you want to change the
security level in the Access 2003 runtime. If I have misunderstood, please
feel free to let me know.
Based on my research, changing the following registry settings of the
following key should help you change the security level of the macro in
Access 2003.
HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Access\Security\Level
If the value is 1, then the macro security of Access 2003 is set to low.
If the value is 2, then the macro security of Access 2003 is set to medium.
If the value is 3, then the macro security of Access 2003 is set to high.
WARNING: If you use Registry Editor incorrectly, you may cause serious
problems that may require you to reinstall your operating system. Microsoft
cannot guarantee that you can solve problems that result from using
Registry Editor incorrectly. Use Registry Editor at your own risk.
Also, you can try to perform the following codes to call the security
dialog. Then you can set the security level manually in the runtime version
of Access 2003.
Dim CBarMenu As CommandBar
Dim CBarCtl As CommandBarPopup
Set CBarMenu = Application.CommandBars("Menu Bar")
Set CBarCtl = CBarMenu.Controls("Tools")
Set CBarCtl = CBarCtl.Controls("Macro")
CBarCtl.Controls("Security...").Execute
Note. Please make sure you selected the Microsoft Office Object Library in
the references
Please feel free to post in the group if this solves your problem or if you
would like further assistance on this issue.
Thanks for posting in community.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! -
www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.