Saving queries

[Jim Pockmire2]

Normally MS-Access (XP) prompts the user to save a query before exiting
query builder. However, on occasion I notice that queries are saved
automatically, without a prompt. Is there a setting that controls this?

 

[Jeff Boyce]

Jim

Access has the ability to turn off Warnings, like "Do you want to save this
query?" and "You are about to delete 4,132 rows... Are you sure?

Something, somewhere, somehow in your database has turned the warnings off
(my guess). You'll first want to find out where and how, and prevent your
db from being left in this condition accidentally (say, if an error
condition happens and the Warnings doesn't get turned back to True). You
may also want to create a simple macro that turns the warnings on.