The action or event has been blocked by Disabled Mode

Question

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 1

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

Answer 2

No. Go to database tools (for 2007) and click checkmark on the Message Bar. Then, after the message bar apears, click on Options, and then Enable. Hope this helps.

Dimitri

Answer 3

How about if the message bar is greyed out?

Answer 4

I'd love an answer to this. Did you ever get one

Answer 5

You may wish to consider self-certifying your projects:

Self-certification, digital certificate, digital signatures

Answer 6

On the ribbon,Go to Database Tools under "Show/Hide", make sure the Message bar is checked (turned on) Then click on the gray message bar, click database options. From there you can modify your security options. Just enable these types of content.

You should be good to go after this.

Answer 7

Thanks Dimitri...your answer worked!

Answer 8

I solved this with Access options.

Go to the Office Button --> Access Options --> Trust Center --> Trust Center Settings Button --> Message Bar

In the right hand pane I selected the radio button "Show the message bar in all applications when content has been blocked."

Closed Access, reopened the database and got the warning for blocked content again.

Answer 9

I agreed with you, Dimitri.