Access 2003 not promting to save changes to queries

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
 
K

Ken Snell [MVP]

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Modifying subform's underlying SQL statement 2
Why does Access 2007 save query changes w/o prompting? 1
Change/Save to aggregate query shuts down Access 6
Changes to query aren't saved Access 2003 3
Cannot quit out of query - forces save 3
Weird Behavior 2
can't save changes in design view (form) 7
changed queries save automatically 8

Top