V
Vexen Crabtree
I have been developing an application (Ziggy) for many years, and find that
sometimes a Form gets 'corrupted': Attempting to open it causes Access to
crash.
Ziggy is only used by me (single user), and its size floats randomly between
6MB and 100MB, though the data in it only increases slowly. The "compact and
repair" tool never fixes a corrupt form. I am using Windows Vista, and Office
2007 SP1.
The solution is sometimes to copy all the items on the form to a new form, or,
sometimes the solution is just to edit the form in Design mode and delete
something, then put it back again. If the form can't be opened in Design mode,
the solution is to import the form from a backup.
Now, in this project,
Whenever I open *any* form or table via buttons on the Ribbon, Access crashes.
I can open them all fine in Design mode, and they operate normally and can
invoke each other properly. But as soon as I open it normally, any attempt to
open a form or table causes it to crash.
Can anyone help?
Q1. What causes these corruptions? I see online that they also occur in split
databases (with front-end and back-end in different files), but as this is a
single-user db, there is no point doing that.
Q2. I knew how to recover individual forms from this, but how to I recover an
entire application?
Q3. Has anyone who experiences similar problems found any general ways around
them?
sometimes a Form gets 'corrupted': Attempting to open it causes Access to
crash.
Ziggy is only used by me (single user), and its size floats randomly between
6MB and 100MB, though the data in it only increases slowly. The "compact and
repair" tool never fixes a corrupt form. I am using Windows Vista, and Office
2007 SP1.
The solution is sometimes to copy all the items on the form to a new form, or,
sometimes the solution is just to edit the form in Design mode and delete
something, then put it back again. If the form can't be opened in Design mode,
the solution is to import the form from a backup.
Now, in this project,
Whenever I open *any* form or table via buttons on the Ribbon, Access crashes.
I can open them all fine in Design mode, and they operate normally and can
invoke each other properly. But as soon as I open it normally, any attempt to
open a form or table causes it to crash.
Can anyone help?
Q1. What causes these corruptions? I see online that they also occur in split
databases (with front-end and back-end in different files), but as this is a
single-user db, there is no point doing that.
Q2. I knew how to recover individual forms from this, but how to I recover an
entire application?
Q3. Has anyone who experiences similar problems found any general ways around
them?