The First Thing To Disable In Access 2007

I have found the first thing you will want to disable in Access 2007. That is the annoying security on VBA Macros that are enabled by default.

Click Options when you try to open your first Database.

I know they are trying to protect less suspecting users here… but if you’re familiar with Database management … there is NO reason for this to be enabled. Instead of just enabling the content, click on the “Open the Trust Center” hyperlink.

This brings you directly to the Macro Settings without having to navigate through Access Options. Enable all Macros .. click ok and be done with it!

Mysicgeek’s Tech Lingo: Macro – In Access this is a series of tasks pulled together into one button click. For Example, you can have a macro query several tables or other queries to make a table with your desired results.