Access does not prompt me to save changes to a form 1

[N2Life]

Ordinarily, when I make changes to a form or query or report and then close it, Access displays the prompt: Do you want to save changes to the design of ....?

For one of my databases, this does not happen. Any changes I make are automatically saved. And when I create a query and try to close it without saving it, Access insists that I give the query a name; there is no option not to save the thing.

This does not happen with any other database I have. I am using Windows XP. My databases are in Access 2000 format.

The only difference I can find so far between this database and others is that it uses a linked table - this would seem to be an irrelevant fact.

Can someone tell me what setting I need to change? I've looked under Tools/Options and don't find anything there. Thanks in advance.

 

[PHV]

Don't you have DoCmd SetWarnings False somewhere ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[N2Life]

Thank you, PHV. That 'thwack!' sound you may have heard was the palm of my hand smacking my forehead. Yes, I had set warnings to false on one form, and failed to reset it.

Mille fois merci!