Auto save queries

[FoFa]

Using Access 2002.
I have a couple databases (out of many) that for some reason the queries, etc. do not ask if you want to save when you exit (from design mode). I can't seem to find an option in either the database or Access to "make it act normal". I just messed up a query because I thought it would ask, but just saved it instead. It must be database specific, but I can't seem to find this setting. Anyone know?

 

[Crilen007]

Huh, thats an odd one. Maybe your access is messed up? Are you sure you didnt press yes by accident?

I don't know if there is an option or not, did you check the MSDN and the help files included in access?

 

[Pat Hartman]

You have turned warnings off either manually or via VBA or a macro. To turn warnings back on to to Tools/Options and change the confirm options on the Edit/Find tab.

Be VERRRRRRRY careful when you turn warnings off with a macro or code. You MUST turn them back on as soon as you can. I create two subs in my databases. One to turn warnings off and the other to turn them back on. In the sub where I turn the warnings off, I turn the hourglass on and vice versa in the other sub. That way I have a visual clue that I have turned warnings off and forgotten to turn them back on.

As you have noticed, this is an extremely dangerous situation in a db where you are doing development.