Corrupt form ?

[Guest]

I have an Access 2000 database with a form in it that appears to be corrupt.
It has been working for some time, several years, and it is only recently
that I discovered this when I tried making some changes.

I tried to make some minor design changes to it (eliminating a picture
background, a change to a textbox), I would save the changes, but when I
would try and close the form, I would get the message asking if I wanted to
save my changes. If I say yes, the same thing happens when I try and close
it. If I say no, the form closes, but then I get the Microsoft ("Windows has
encountered a problem . . .") message and then the application quits, and the
form disappears completely from the app.

I have even tried saving the form without making any changes, and I still
get the Microsoft error message, with the application quitting and the form
disappearing from the app.

The database has been compacted and repaired. I have tried pulling up a
form from an old backup, but apparently this has been a problem for a long,
long time (we just haven't needed to make any changes or save it), and I have
not been able to pull up a backup copy where this isn't happening.

None of the other forms in the application are having this problem.

I am assuming this form is corrupt, and wondering if there is any way at all
of repairing it, or if I'm stuck recreating it from scratch (there are
probably 150 different controls on it, this will not be fun!

Thanks in advance for any suggestions

 

[Guest]

What I'd do is to remove many controls (1/2?) then see if the problem still
happens. If it does, remove the other 1/2 of the controls and see if it
happens. From there I'd check the Record Source property for the form if it's
based on a query. I'd remove any calculated fields. And try again.

If any of these fixes the problem. Start again from a backup and remove
fewer items until you figure out which item is causing the problem. Then just
fix the problem.

This may or may not work.
James

 

[Jeff Boyce]

Karen

Have you also tried creating a new (empty) form and importing all the
objects/code from the suspect form?

Have you tried (first saving a backup copy) using the undocumented
/decompile switch (you can find more on this via a Google search)?

Regards

Jeff Boyce
Microsoft Office/Access MVP