Here's a situation - I have an update query on a large table. The query is open in design view. I hit "Run". It starts to run. I then get an audio chime, and a box displays that says "There isn't enough disk space or memory to undo the data changes this action query is about to make. Do you want to run this action query anyway? [Yes] [No]"
That's fine. I don't mind getting this message. I expect it. I click "Yes" and the query goes on and finishes up.
But suppose I don't have the query open in design view. Suppose (a) I have just clicked on the icon to run the query, or (b) the query is part of a Macro that I have executed.
In that case, I get the audio chime but the dialog box does not display. And I am stuck! It's like Access thinks it has displayed the box, and is waiting for me to click "Yes", but there's no place for me to do that. Access then goes into "Not Responding" mode and I end up having to close it down and reopen it. Basically this means that a lot of multi-query macros are unexecutable, because invariably they go into "Not responding" mode somewhere in the middle.
Is there a way to get Access to just display the darn box? Is this some setting I can select?
Thanks for your help!