auto save query changes?

[LucasH]

Hi,

Using Access 2003 and haven't seen this behavior before and it's driving me mad.

When making changes to query design, upon closing, I do not get prompted to save changes, Access just autosaves whatever I change. Or when i create a new query, and attempt to close the query, I have to save it, I can't discard it.

Is there a setting for this? I don't want Access to save changes unless I tell it to, I just lost a lot of work because of this/

 

[GingerR]

Your Warnings have been turned off some how--usually with me it's because some code has failed in the middle of running so the Warnings are not turned back on.

Go into a code module, put

Function Admin()
Docmd.setwarnings True
End Function

and run it. I keep that function there all the time for just such a case.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html