The action or event has been blocked by Disabled Mode

mattruma picture mattruma · Sep 19, 2008 · Viewed 101.4k times · Source

I am using Microsoft Access 2007 to move and massage some data between two SQL Servers. Yesterday everything was working correctly, I was able to run queries, update data, and delete data.

Today I opened up the Access database to finish my data migration and am now receiving the following message when I try to run some update queries:

The action or event has been blocked by Disabled Mode.

Any ideas what this is talking about?

Answer

jwarzech picture jwarzech · Sep 19, 2008

Try and see if this works:

  1. Click on 'External Data' tab
  2. There should be a Security Warning that states "Certain content in the database has been disabled"
  3. Click the 'Options' button
  4. Select 'Enable this content' and click the OK button