I know we have to keep up with the times but Access 2007 is frustrating the heck out of me. I am working on a DB and when I change a query it does not prompt me to save it when I close it. Instead it automatically saves it. THis has caused me much heartache as I was playing what-ifs with a query and then closed it. No prompt to save and it saved all the junk I was doing. Before I would get a do you want to save the changes and just say no.
Is there a setting/property/preference that controls this behavior and where can I find it?