Security Warnings - MS Access 2007

 
This is one of those situations where Microsoft protects you from yourself – in a new installation of Office 2007, all macros (i.e., VBA procedures) are disabled without notification.  Microsoft calls this protecting you from potentially unsafe macros; what it amounts to is that your own code won't run.  This type of protection I don't need! 

To fix it:

  1. Perform above change then
  2. Click the Access Options button on the Office menu,
  3. select Trust Center in the left pane,
  4. and click the Trust Center Settings button. 
  5. In the Trust Center window, select Macro Settings in the left pane,
  6. and select the Enable all macros option. 
  7. Close and reopen Access, and your application will run.

Printable .pdf document with more information.

In MS Access 2003 or earlier, the interface is different (and much simpler):  Select Tools, Macro, Security, and select the Low option in the Security dialog.
 

Back<

04/18/2008