Access 2003 Macro Security

[Ntl News Group]

I understand that when using Access 2003, the security settings prevent
the VBA code from running correctly and need to be set to the Low
setting. My question is: Can this be done automatically using VBA, in
other words, when my DB opens can it check to see if running Access 2003
and if so then change the macro security settings to low?

Regards

[Keith Wilby]

"Ntl News Group" <ia********@ntlworld.comwrote in message
news:RW******************@newsfe4-win.ntli.net...

>I understand that when using Access 2003, the security settings prevent the
VBA code from running correctly <snip>

What makes you think that? Have you tired running code? I work for a
corporation whose policy forces macro security to the "medium" setting and
my code runs just fine.

Keith.
www.keithwilby.com

[Tom van Stiphout]

On Thu, 11 Jan 2007 13:27:13 GMT, Ntl News Group
<ia********@ntlworld.comwrote:

These warnings were designed to alert users of macro viruses. If it
could be set programmatically, that would defeat the purpose, wouldn't
it?

The correct way to get around these warnings is to digitally sign your
app with a VBA Certificate. Plenty of info about that in the Help
file.

-Tom.

>I understand that when using Access 2003, the security settings prevent
the VBA code from running correctly and need to be set to the Low
setting. My question is: Can this be done automatically using VBA, in
other words, when my DB opens can it check to see if running Access 2003
and if so then change the macro security settings to low?

Regards