Access - Set warnings set to no - not working

Thanks Rey - where is the action Queries check box.

@exp vg,


what version of access are you using?

here is the image for A2010

you can set by clicking on

File > Options > Client Settings

Although you can do what Rey is recommending, I strongly recommend against that as well.  When running queries manually, it is advantageous to have the warnings popup, just in case you got your where clause wrong and are about to delete or update 100's of records instead of 5 or 10.

Thank you both. At this point - I have tested and automated the database as much as possible - so just need to ensure that the pop-ups do not appear.

Let me please give this a try and get back to you.

Here is an update - my Action Queries was already unchecked.

When I click on the Office Button (I take this is the button at the bottom left of the screen) - I do not see Access options to complete this step.

The issue I am having is that when I run the database with all included Queries and Macros without flaw or error, the pop-ups do not arise.

However, if there is one mis-step (i.e mis-labeled data source, etc.) and the database operations are stopped pre-maturely, when I try to relaunch the database again, I get the pop-ups "The table X will be replaced" Yes/No, etc.

Is there a way to suppress the pop-ups after database operational completion has been disrupted, and I have to restart?

Thank you.

"Access options "  is at the lower right corner  of the Menu beside Exit Access

Then I have it - I have gone to Access Options - Client Settings - Confirm - unchecked Action Queries.

However, the pop-ups still appear if the database operations is disrupted.

Please advise.

I can't certainly know what causing the pop-ups without seeing your db.

just make sure that if you set the warning message in vba

docmd.setwarnings 0

' run your codes here

'set the warning back to true
docmd.setwarnings -1

Thank you.