No save dialogue after modifying db objects

[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

 

[Dirk Goldgar]

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!

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.

 

[Peter Stone]

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.

 

[Gina Whipp]

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

 

[Dirk Goldgar]

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.

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?

 

[Peter Stone]

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

 

[Peter Stone]

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.

 

[Gina Whipp]

Peter,

Well, glad it got resolved, just interesting that you had to restart the
machine.

--
Gina Whipp

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

http://www.regina-whipp.com/index_files/TipList.htm