simplest way to enable macros in Access 2007

[Amanda]

My office recently upgraded to Office 2007, and now we have to enable the
macros every single time we open up the database in order for our search
boxes to function.

What can I do for Access to trust the macros in our company database?
(without having to go around and make it a trusted source on every single
machine. we have a high rate of computer turnover- I should not have to set
this up every time we change out a computer.)

Thanks, Amanda

[Albert D. Kallal]

Post by Amanda
My office recently upgraded to Office 2007, and now we have to enable the
macros every single time we open up the database in order for our search
boxes to function.
What can I do for Access to trust the macros in our company database?
(without having to go around and make it a trusted source on every single
machine. we have a high rate of computer turnover- I should not have to set
this up every time we change out a computer.)
Thanks, Amanda

To turn this feature off, just go:

office button->access options->trust center

click on the "trust center settings..." button (on the right side)

now, on the left side...choose macro settings...

now choose

Enable all macros

You never get any prompts or nags....