No save dialogue after modifying db objects

  • Thread starter Thread starter Peter Stone
  • Start date Start date
P

Peter Stone

Access 2003 WinXP Pro

In the middle of a session my database has suddenly stopped asking if I wish
to save changes after I have modified Queries, Forms, etc. I ran detect and
repair, but no go. I looked in Tools/Options, but found nothing that seemed
to be causing this behavior. Any suggestions please!

Thank you.

Peter
 
Peter Stone said:
Access 2003 WinXP Pro

In the middle of a session my database has suddenly stopped asking if I
wish
to save changes after I have modified Queries, Forms, etc. I ran detect
and
repair, but no go. I looked in Tools/Options, but found nothing that
seemed
to be causing this behavior. Any suggestions please!
Click to expand...


Do you by any chance have code that was executed that uses the statement,

DoCmd.SetWarnings False

? If so, and if somehow you managed -- possibly due to an error
occurring -- not to turn the warnings on again by executing

DoCmd.SetWarnings True

then you'll get this behavior. Any time you turn off warnings, you need to
make sure that you have error-handling in place that ensures that the
warnings always get turned on again, no matter what happens.
 
Thanks Dirk
No I didn't have that code. Just in case, I ran DoCmd.SetWarnings True on a
form, but it didn't help.
 
Peter,

Oddly, enough I get this from time to time... I run Compact & Repair and
then close Access and restart and all is well. I wish I could tell you why
this works but it just does... for me anyway.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
Peter Stone said:
Thanks Dirk
No I didn't have that code. Just in case, I ran DoCmd.SetWarnings True on
a
form, but it didn't help.
Click to expand...


Hmm. And you have the Tools -> Options... -> Edit/Find -> Confirm options
all checked?

I'm puzzled. I suppose it could be some form of corruption, but I don't
want to jump to that conclusion. What happens if you create a new blank
database and import all the objects from the original. Does the new
database behave the same way?
 
Interesting. The problem fixed itself when I restarted the computer.

Because I'm making frequent changes, I make regular backups. My last two
backups from yesterday were exhibiting the same problem. The first backup
from yesterday was OK. When I restarted all versions were OK. Who knows!

By the way, tools options etc. etc. were all checked.

Thanks

Peter
 
Hello Gina
Interestingly running compact and repair and restarting Access wasn't
sufficient. It was only when I restarted the computer that it fixed itself.
 
Back
Top