Cannot quit out of query - forces save

[Ann Scharpf]

I've poked around help and the newsgroup trying to figure out what I did but
I can't find the answer. All of a sudden today, I cannot modify a query and
then abort the changes. Access is forcing me to save every new query.
Changes to existing queries are saved automatically.

I know I must've changed some setting but I've looked through Tools >
Options and I can't see anything that governs this behavior. I'd appreciate
any advice you can give me on how to reset this mode. Thanks.

 

[Michel Walsh]

Use TransferDatabase Method with the optional argument StructureOnly set to
true.

Vanderghast, Access MVP

 

[John Spencer]

Somehow you have managed to Set Warnings Off in your database.

You may have code somewhere that is running (in a startup procedure or a
macro) that is setting warnings off.

Try executing the following line in the VBA window.
docmd.SetWarnings true


'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

 

[Michel Walsh]

Sorry, apparently, that is not the thread to which I was expecting to
reply...


Vanderghast, Access MVP