Security bar

P

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" ?
 
A

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.
 
P

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 ?
 
P

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top