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.