Perhaps a simple question? In 2007, automatic macro access per database.

N

njankovic

Hi. In Access 2007, is there a way to set a database to automatically
allow macros rather than blocking them when you open the database?

If not, can Access 2007 be allowed to allow all macros all the time?

Cheers,

Nick
 
A

Allen Browne

Add the folder where you keep your databases as a Trusted location.

The setting is under:
Office Button | Access Options | Trust Center | Trust Center Settings

If you have used previous versions of Access, this article might be useful:
Converting to Access 2007
at:
http://allenbrowne.com/Access2007.html
 
Top