Enable Macros in Microsoft Access 2007
Step 1 – Select the Office button located on the top left.
Step 2 – Select “Access Options”, located at the bottom.
Step 3 – Access Options window is open. Select the “Trust Center”
Step 4 – Select “Macro Settings”
Step 5 – Choose “Enable Macros (not recommended; potentially dangerous code can run)”
Step 6 – Click “OK”.