Database development and training for Birmingham and the midlands
Specialists in Microsoft Access and Visual Foxpro database training and development
I am happy to hear from existing clients but I am taking no new calls.
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 dialog. Click 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 button.
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 thebutton to add a new location:
In my case I know that I have many directories under C:\Dev so I ticked theoption 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.