Access 2003 not promting to save changes to queries

  • Thread starter Thread starter r0adh0g
  • Start date Start date
R

r0adh0g

I open a query in design view in Access and make some modifications.
When I close the query, it does not prompt me to save the changes.
It does save the changes, but what if I don't want them saved? Is there
a setting somewhere that I don't know about?\

rh
 
Chances are good that you've run some code that turned off the warnings
(DoCmd.SetWarnings False).

Open Visual Basic Editor, make Immediate Window visible, and run this
command in that window:
DoCmd.SetWarnings True

That should fix it for you. Anytime code turns warnings off, be sure to
always turn them back on; especially if you have error handler code --
always put the DoCmd.SetWarnings True step in the error handler if you've
turned warnings off in the procedure.
 
Back
Top