Disable macro security with vba? reg-file?

[Jesper F]

I have an app that runs on a total of 50-60 machines in four offices.
The IT-staff on those locations helps me with installs but they are spending
much time instructing users how to disable macro security. The app won't run
properly until that's done.
Is it possible to automatically disable macro security with vba or some
change to the registration database?

/ Jesper

 

[Alex Dybenko]

Hi,
here 2 keys you need to set:

Root:
Local Machine
Key:
Local Machine Software\Microsoft\Office\11.0\Access\Security
Name:
level
Value
#00000001

Root:
Local Machine
Key:
Local Machine SOFTWARE\Microsoft\Jet\4.0\Engines
Name:
SandBoxMode
Value
#00000002

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[Jesper F]

here 2 keys you need to set:

Root:
Local Machine
Key:
Local Machine Software\Microsoft\Office\11.0\Access\Security
Name:
level
Value
#00000001

Root:
Local Machine
Key:
Local Machine SOFTWARE\Microsoft\Jet\4.0\Engines
Name:
SandBoxMode
Value
#00000002

That sounds good Alex. Are these the only two keys I need to set?
Will it cause problems for the user when setting these?
Can I do it from the db-file?
Thanks.

/ Jesper

 

[Alex Dybenko]

Hi,

That sounds good Alex. Are these the only two keys I need to set?

yes. Are you using 2003 or 2007? in 2007 you can also specify trusted
location

Will it cause problems for the user when setting these?
Can I do it from the db-file?

Not sure you can, if macro security is set to high - then you can't run code
to update registry

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com