Not prompting to save changes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Has anyone ever seen this before? I am using Access 2003 and while in design
mode of my queries, as I put in a criteria for testing, and close it, it
usually prompts me to save and I say no because it is only a test. But
recently, after converting my database from Access 2000 file format to Access
2002-2003 format, when I close, it automatically saves my changes whether I
want it to or not.

I have been coding in Access and VBA for a number of years and have NEVER
experienced this. I tried to search the knowledge base to see if this is a
bug or if there is some setting that needs to be unchecked but cant find
anything.

Thank you in advance for your help.

Diane
 
Open the VBA window and type
Docmd.SetWarnings True

If that takes care of the problem, then it is likely that somewhere in yuor
VBA code or in a macro SetWarnings is being set to false and then not set
back to true.

Also check Tools: Options settings

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
I checked Tools, Options and there is no place to set where it eliminates
prompting.

I will check my code for the warnings and thank you.

Diane
 
Just wanted you to know that I had my "Set Warnings" below my "Quit"
statement so it was never setting it back to true. THANK YOU SO VERY VERY
VERY MUCH FOR THIS!!!! It has been driving me crazy for a while and I knew
it didn't make sense.

Diane
 

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

Back
Top