Stop Disabled mode from blocking a query
By default, if you open a database that does not reside in a trusted location, or if you have not chosen to trust the database, Access prevents all action queries — append, update, delete, or make-table queries — from running.
If you try to run an action query and it seems like nothing happens, check the Access status bar for the following message:
This action or event has been blocked by Disabled Mode.
When you see that message, do the following:
Enable blocked content
On the Message Bar, click Options.
The Microsoft Office Security Options dialog box appears.
Click Enable this content, and then click OK.
Run your query again.
If you don't see the Message Bar
Click the Database Tools tab, and in the Show/Hide group, click Message Bar.
Alan
