Access 2007 Trust Center
If you're trying to develop Access databases then the warning messages that Access 2007
displays about the dangers of macros can become irritating.
It is however fairly easy to use the Trust Center to tell Access that the databases that
it finds on your own PC can be trusted not to hold malicious code. In my case I do all my
development work in a folder named Dev and I've set up the Trust Center so that it
will not keep warning me about the VBA code that I'm trying to write.
The Trust Center
Start by opening the
button then click
in the bottom right of that window to open
the dialog. There's a list of options in the left-hand pane of the dialog that opens.
Select from the list and then click the
The next dialog shows you the locations that are trusted by Access. By default, the only
entry is the folder holding the code for the Access Wizards. Click the
button to add a new location:
In my case I know that I have many directories under C:\Dev so I ticked the
on the new folder dialog to make sure that all of my databases would be classified as
The next time that you open Access you'll be able to open your own databases without
having to override the warning about the VBA macros.