Access 2007 disables macros by default, and then you have to go through the new "Trust Centre" to find it. Here's the simple procedure to switch it off.
More information about formatting options
Quarterly newsletter for UK businesses and runPCrun customers