If you’re a user of Microsoft Access 2007, there’s a good chance that you’re using some features that are currently disabled. This includes features like password protection and autofill. If you don’t want to disable these features, it’s best to do so before the end of the year. Microsoft is going to start disabling these features in order to improve performance and security. If you don’t disable these features, your data could be at risk if someone gets access to your account or if something goes wrong with your computer.
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.
