Help with Runtime and Macro Security

  • Thread starter Thread starter Chaplain Doug
  • Start date Start date
C

Chaplain Doug

I have created a DB and packaged it with the Acess
packager. The database is run using the runtime module so
it will run on any machine. However, when installed and
run on other machines (I tried it today on a Windows XP
with Access 2002), the warnings about running macros comes
up followed by two more warning dialogs. I do not want
users to have to go through these controtions and
frustrations every time they try to use the DB! I can
turn them off on my machine, as Access 2003 allows me to
set the Macro security to low. However, on other machines
(like the Access 2002 system) there is no way I know of to
set the Macro security low so that the warnings do not
come up. This is absolutely frustrating! Anyone have a
suggestion? (Keep in mind that I am using Access Runtime
2003 with this distribution). Thanks.
 
Hi,

TheSecurity Level can be easily reset in Access full version (Tools | Macro
| Security). However, in the Access runtime version, we cannot reset it
with the User Interface.

To get rid of this message, you can modify the following Registry Keys on
the client machine:

#Warning# Please BACKUP the Registry before you modify it. 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.

(Please also note that if the key doesnt exist, you can just add it and set
the correct value)

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines]
SandBoxMode = DWORD: 00000003

[HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Access\Security]
Level = DWORD: 00000001

After modifying the above registry keys, start the application and see if
the two warning messages appear.

I hope this helps

Regards

Mark

This information is provided "as is" and confers no rights, or expresses
any warranties.
 
Back
Top