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.

Security warning in Access 2007

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 Access options dialog. Click the Office button then click Access Options 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 Trust Center from the list and then click the Trust Center Settings button.

Access 2007 Trust Centre

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 Add new location... button to add a new location:

Access 2007 Trust Centre settings

In my case I know that I have many directories under C:\Dev so I ticked the Subfolders of this location are also trusted option on the new folder dialog to make sure that all of my databases would be classified as being trustworthy.

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.

MS Access technical tips

Visual FoxPro technical tips

General Tips

 

More tips from Alvechurch Data

Access 2007 file extensions

Access 2007 has new file extensions.

Read More

Multiple values in Access 2007

Access 2007 allows us to store multiple values in a lookup table.

Read More