More of an annoyance than anything else, but I couldn't find any information on it in Google.
I'll often create a query in Access 2007 to test something, or quickly grab some results on a one time basis. I don't want to save these queries, as they're only good for one use.
Not always, but often, Access won't close this query without me saving it, which then means I have to later delete it. This can prevent me from closing Access until I've saved it, and creates a derth of unwanted queries.
Why is this happening? Is there something in particular that sets it off?
The Track name AutoCorrect info path was not what did it for me. Rather it turns out I had left DoCmd.SetWarnings False set. Going into the immediate window and running DoCmd.SetWarnings True brought back the old "Do you want to save this query Yes/No/Cancel" window.