Setting Macro Security using VBA

[Sun G]

Since I have converted my Access97 application to Access2003, I am
getting an warning while opening the Access Database. When Macro
Security level set to Low, its working fine.

Now, I want to set Macro Security using VBA and not directly. As this
application is in use at 100s of place. Can anyone suggest me how can I
set Macro Security level to Low using VBA.

Thanks
Sun

*** Sent via Developersdex http://www.developersdex.com ***

[Rick Brandt]

Re: Setting Macro Security using VBA

Sun G wrote:[color=blue]
> Since I have converted my Access97 application to Access2003, I am
> getting an warning while opening the Access Database. When Macro
> Security level set to Low, its working fine.
>
> Now, I want to set Macro Security using VBA and not directly. As this
> application is in use at 100s of place. Can anyone suggest me how can
> I set Macro Security level to Low using VBA.
>
> Thanks
> Sun
>
> *** Sent via Developersdex http://www.developersdex.com ***[/color]

It would be pretty stupid if dangerous code also had the ability to turn off
the warnings for dangerous code wouldn't it?

You can use a vbscript to open your app in a session with macro security set
to low, but that would mean creating a shortcut to the script for all of
your users.

Search these groups for posts from TC. He explains how to do this all the
time.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com