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

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Pietro" <Pietro@discussions.microsoft.com> wrote in message
news:F8D009AF-2708-4B24-8206-6EE35586DBA7@microsoft.com...
> 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" ?

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Pietro" <Pietro@discussions.microsoft.com> wrote in message
news:F8D009AF-2708-4B24-8206-6EE35586DBA7@microsoft.com...
> 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" ?

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" wrote:

> 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.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Pietro" <Pietro@discussions.microsoft.com> wrote in message
> news:F8D009AF-2708-4B24-8206-6EE35586DBA7@microsoft.com...
> > 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" ?
>
>

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" wrote:

> 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.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Pietro" <Pietro@discussions.microsoft.com> wrote in message
> news:F8D009AF-2708-4B24-8206-6EE35586DBA7@microsoft.com...
> > 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" ?
>
>

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Pietro" <Pietro@discussions.microsoft.com> wrote in message
news:C8B1C97E-C337-4A9E-BC03-AF65AB627993@microsoft.com...
> 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" wrote:
>
>> 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" <Pietro@discussions.microsoft.com> wrote in message
>> news:F8D009AF-2708-4B24-8206-6EE35586DBA7@microsoft.com...
>> > 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" ?

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Pietro" <Pietro@discussions.microsoft.com> wrote in message
news:C8B1C97E-C337-4A9E-BC03-AF65AB627993@microsoft.com...
> 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" wrote:
>
>> 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" <Pietro@discussions.microsoft.com> wrote in message
>> news:F8D009AF-2708-4B24-8206-6EE35586DBA7@microsoft.com...
>> > 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" ?

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

"Allen Browne" wrote:

> Sounds like you need to script the trusted location:
> http://accessjunkie.com/faq_33.aspx
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Pietro" <Pietro@discussions.microsoft.com> wrote in message
> news:C8B1C97E-C337-4A9E-BC03-AF65AB627993@microsoft.com...
> > 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" wrote:
> >
> >> 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" <Pietro@discussions.microsoft.com> wrote in message
> >> news:F8D009AF-2708-4B24-8206-6EE35586DBA7@microsoft.com...
> >> > 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" ?
>
>

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

"Allen Browne" wrote:

> Sounds like you need to script the trusted location:
> http://accessjunkie.com/faq_33.aspx
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Pietro" <Pietro@discussions.microsoft.com> wrote in message
> news:C8B1C97E-C337-4A9E-BC03-AF65AB627993@microsoft.com...
> > 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" wrote:
> >
> >> 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" <Pietro@discussions.microsoft.com> wrote in message
> >> news:F8D009AF-2708-4B24-8206-6EE35586DBA7@microsoft.com...
> >> > 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" ?
>
>