Forced to save query

[pbuethe]

Sometimes when I create a quick query just to check something, then try to close the query, I am prompted for the name to save the query to instead of being asked if I want to save the changes to the query. I cannot close it unless I save it. What causes this and how can I fix it so it will ask if I want to save? Thanks for your assistance.

 

[khawar]

There may be another option "NO" you can select that for not saving changes

 

[pbuethe]

There is OK and Cancel: OK saves the query, if I click Cancel the query stays open.

 

[DJkarl]

Someone or some process has turned warnings off in the database, you can create a macro or use VBA code to turn warnings back on.

 

[Pat Hartman]

This may happen if you have other unsaved objects open.