Trust Center Settings, can this be turned off

[AccessHar]

When I open a DB in Access 2007, I am unable to do anything until I click the
button "Options..." of the Security Warining Certain content in the database
has been disabled. When I click the "Options..." I must hen click the enabled
radio button. And then I can use my database.

I am not happy with this Access 2007, or Vista, can't find anything
anymore...... Can somebody please tell me how I can get rid of this feature
so that I the future I can open my DB and use it without any further bother
of clicking Options..... In developing databases for a Finance department,
they do not know that they have to carry out this routine. It is very
annoying.....

Thank you

 

[Scott McDaniel]

When I open a DB in Access 2007, I am unable to do anything until I click the
button "Options..." of the Security Warining Certain content in the database
has been disabled. When I click the "Options..." I must hen click the enabled
radio button. And then I can use my database.

I am not happy with this Access 2007, or Vista, can't find anything
anymore...... Can somebody please tell me how I can get rid of this feature
so that I the future I can open my DB and use it without any further bother
of clicking Options..... In developing databases for a Finance department,
they do not know that they have to carry out this routine. It is very
annoying.....

Do you mean that you've deployed a database, and the endusers are getting this warning? If that's the case, then you'll
need to either (a) purchase and use a Digital Certificate to sign your code, then instruct users how to properly enable
the Sandbox mode, (b) add the database to a Trusted Location on the user's machine or (c) set the Macro Security level
to something other than the default on the enduser's machine. Note this could potentially leave you unprotected from a
macro virus, so make sure that the "powers that be" fully understand what you're doing if you choose this option. Note
also that these settings are machine settings; you can't set them in your app on your machine and expect them to carry
over to user machines.

To set Macro Security, click the Office button (top left corner), then click Access Options (bottom of the dialog),
select Trust Center, then click Trust Center Settings. Select Macro Settings, and select one of the other Options (for
example, the first or last option will stop the notification). Again, please make sure you understand what's going on
with the options before choosing one.

If you mean that during development you're getting this option, then the easiest way to avoid it is to add the database
location as a Trusted Location. To do that, open Access, then click the Office button (top left corner), then click the
Access Options button at the bottom. Select Trust Center, then click Trust Center Setings .... next, select Trusted
Locations, then Add New Location ... locate the folder hosting your database and add it.

Thank you

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com