C
CrazyAccessProgrammer
What exactly causes form corruption?
Sometimes I'll be working on a form for a few hours and suddenly I'll notice
odd behavior with the form with things that I had NOT been working on with
the form that suddenly don't work right and used to work right. Then I'll
spend a long time debugging because I'll think it's something I did that
screwed things up. Eventually though, when nothing I do seems to fix the odd
behavior, I'll copy a backup copy of the form from a backup copy of my
database and suddenly the form behaves just fine.
For example, I was opening a popup form from a parent form. I'd pass an
OpenArgs variable from the parent form so that my popup form would open and
go to the OpenArgs record. Suddenly I start to notice that the popup form
isn't moving to the OpenArgs record anymore. I debug for a while with no
luck. Then I copy a slightly earlier copy of the popup form from a backup
copy of my database changing nothing with the code that runs to open the
popup form from the parent form (which passes the OpenArgs variable) and
everything works again.
So my question remains, what exactly causes a form to become corrupt where
the only real solution is to obtain a backup copy of the form or re-create
the form? Is there anything I can do to avoid this?
I ask this question also because it's very disconcerting when it happens. It
makes me feel like my database isn't reliable.
Sometimes I'll be working on a form for a few hours and suddenly I'll notice
odd behavior with the form with things that I had NOT been working on with
the form that suddenly don't work right and used to work right. Then I'll
spend a long time debugging because I'll think it's something I did that
screwed things up. Eventually though, when nothing I do seems to fix the odd
behavior, I'll copy a backup copy of the form from a backup copy of my
database and suddenly the form behaves just fine.
For example, I was opening a popup form from a parent form. I'd pass an
OpenArgs variable from the parent form so that my popup form would open and
go to the OpenArgs record. Suddenly I start to notice that the popup form
isn't moving to the OpenArgs record anymore. I debug for a while with no
luck. Then I copy a slightly earlier copy of the popup form from a backup
copy of my database changing nothing with the code that runs to open the
popup form from the parent form (which passes the OpenArgs variable) and
everything works again.
So my question remains, what exactly causes a form to become corrupt where
the only real solution is to obtain a backup copy of the form or re-create
the form? Is there anything I can do to avoid this?
I ask this question also because it's very disconcerting when it happens. It
makes me feel like my database isn't reliable.