Hey

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?

Sounds like you have turned off the warnings.

Are you using the line of code


anywhere in your database. If you are, you might be forgetting to turning back on.

press ctrl-g to get to the immediate window.

Type:

Docmd.setwarnings true

and press enter

I did turn it off in a module but turned it back off. The problem happens on one computer but not another