As an update to this post, this is how you enable Access 2007 to work with your Access applications that require extended security.
1) Open "Customize Quick Access Toolbar" menu to the right of the office button
2) Select "More Commands"
3) Click "Trust Center" menu button on sidebar
4) Click "Trust Center Settings" button on main pane
5) Click "Macro Settings" menu button on sidebar
6) Select "Enable all macros"
7) Click "OK" to close Trust Center
8) Click "OK" to close Access Options