By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,422 Members | 1,615 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,422 IT Pros & Developers. It's quick & easy.

Setting Macro Security using VBA

P: n/a
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 ***
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Sun G wrote:
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 ***


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
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.