Cannot quit out of query - forces save

  • Thread starter Thread starter Ann Scharpf
  • Start date Start date
A

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.
 
Use TransferDatabase Method with the optional argument StructureOnly set to
true.

Vanderghast, Access MVP
 
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
'====================================================
 
Sorry, apparently, that is not the thread to which I was expecting to
reply...


Vanderghast, Access MVP
 
Back
Top