Security Warning Bypass

[bodhisatvaofboogie]

I have a security warning that pops up when opening a database. I'm using an
excel macro to open up the databse and run a macro within it. Is there any
line of code I can plug into the macro for access to automatically choose the
open option on the warning? I'm trying to allow it to open without having to
click anything, but cannot change the macro security settings without system
administrator permission and would like to avoid having to go that route if
possible as there would be excessive red tape. SO in short, if there is a
line of code that will automatically click the OPEN button on the warning all
will be solved. Make sense? Thanks in advance.

 

['69 Camaro]

Hi.

Make sense?
Yes.

SO in short, if there is a
line of code that will automatically click the OPEN button on the warning
all
will be solved.

As long as the database doesn't have User-Level Security implemented, use
Automation Security to set the Macro Security level to Low for the Access
session. (The Macro Security level stored in the Windows Registry will not
be affected.) Please see the following Web page for the example VB Script:

http://www.accessmvp.com/JConrad/accessjunkie/macrosecurity.html

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[bodhisatvaofboogie]

Thanks a bunch, that fixed it right up!!!

Hi.


As long as the database doesn't have User-Level Security implemented, use
Automation Security to set the Macro Security level to Low for the Access
session. (The Macro Security level stored in the Windows Registry will not
be affected.) Please see the following Web page for the example VB Script:

http://www.accessmvp.com/JConrad/accessjunkie/macrosecurity.html

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

['69 Camaro]

Thanks a bunch, that fixed it right up!!!

You're welcome! Glad it worked out.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[Harry]

Hi,

You could create (assuming you are using Windows as OS) a digital
certificate yourself on your computer.
adding the certificate within the db (at the vba screen). The first time
opening the db it will ask you to trust the certificate. just answer yes to
it and the next time the db will open without the security warning as it
trusted.

Succes
Harry