Weird Behavior

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

Guest

I have a database that contains a bunch of Queries. Periodically, I will
notice that when I open a query in design view, make some changes and close
it, Access does not prompt me if I want to save the changes, it just does it
for me. Kind of a hassle, cause I lose my original design. I would expect
it to ask me if I want to save the changes, then I could say no and revert
back to the original. If I exit Access then come back in, It usually works
ok for a while. However, it is a pain, cause I never know if it will fail
until I have already lost my design. Sometimes, I have to re-boot to get it
to work as expected. Any ideas?
 
Do you have code in your database that runs this step:

DoCmd.SetWarnings False

If that code does not also turn the warnings back on, then the behavior that
you describe will result.

Anytime code turns off the warnings, it must explicity turn them back on.
Where most people "err" is that they do not put the "turn it back on" step
in the error handler part of procedures' code, and if an error handler runs,
the warnings are not turned back on.
 
That happens to me before, too.

I am not sure whether it is coincidental or not but the problem seemed to
disappear since I started keeping my OS & Office patched & up-to-date.

If you have,t patched your OS & Office installation, suggest you use the
Microsoft Update regularly.
 
Back
Top