Security bar

[Pietro]

Hi,
I have the following problem with my Access dataabse:
Evertime I open the database i get the security warning bar,users should
press on options and select "Enable this content" in ordr to proceed to the
database...
Is there a VB code that i can run on the on load event of my main form to
set this option to automatically "enable this content" ?

 

[Allen Browne]

You don't mention which version this is.

If Access 2007, you need to tell it your database is in a trusted folder. Go
to:
Office Button | Access Options | Trust Center | Trust Center Settings
and Add your folder there.

If Access 2003, go to:
Tools | Macro | Security
and set the macro security to Low.

 

[Pietro]

Thank you for your reply..My version is Access 2007
I know the steps you mentioned below well,I just need to get a VB code to
automatically do this on behalf of users once they open the database....
Example I use the below code to set the property "Hidden objects" to false
once user open the database:
Application.SetOption "Show Hidden Objects", False
Now I'm wondering can i enable all macros using the same way ?

 

[Allen Browne]

Sounds like you need to script the trusted location:
http://accessjunkie.com/faq_33.aspx

 

[Pietro]

I checked the below sites,but i see that it's so much hard to carry out all
these settings,especially because i have 50 machines in my company,once a
user logs off,all settings are lost and must be redone again,I need an
automated process that takes place everytime users open the tool...