Form repeatedly becoming corrupt

[Brian]

Access 2003

I have a form that has become corrupt perhaps seven or eight times in the
last week. It is a complex, but not overly-so, form that interacts with
MapPoint using the MapPoint API.

These attempts produce no response when the form is corrupt:
Double-click of form
Click Design
Attempt to paste within current DB or to another

These attempts produce "no current record":
SaveAsText
Import form into another DB

Attempting to open form using DoCmd.OpenForm results in error 2001: "you
cancelled the previous operation"

I already tried creating a new MDB from scratch and importing this form from
a pre-corrupt version. It cooperates for a few hours, and then suddenly,
during a repair, decompile, or just form save, produces an Access erorr and
is again corrupt. I have to keep my backups very current (every few minutes)
to ensure I can get back a fairly current version to begin development again.

The MDB as a whole is not corrupt. All other objects work fine.
It never happens when running the applicaiton - only while under development.
I have never seen this problem before this app.

I have a copy of the form in a non-corrupt version, but I just made a
boatload of code changes before it again became corrupt and really want to
get back its module, at the very least.

 

[Brian]

Weird followup note:

I open any module, then view the Object Browser.

I can see my corrupt form there with all its objects, and when I
double-click it, I can see all ththe code from the form's module (whew!);
however, the form still does not work, and I now have to recreate it from an
older version.

I still need to know how/why it keeps going corrupt and how I might be able
to retreive it in a workable form from what I have found.

 

[John W. Vinson]

I still need to know how/why it keeps going corrupt and how I might be able
to retreive it in a workable form from what I have found.

http://www.granite.ab.ca/access/corruptmdbs.htm

has a thorough discussion of recovery from corruption. As noted elsethread
this may require rebuilding the form (you should be able to copy and paste the
VBA code into Notepad and reinsert it into the new form).

 

[Tony Toews [MVP]]

I have a form that has become corrupt perhaps seven or eight times in the
last week.

I would try importing the entire FE MDB into a new MDB. This seems to
help by cleaning up some minor corruption that gets rapidly worse over
time.. Note that compact and repair cleans up tallest an indexes but
doesn't generally clean up this kind of object corruption.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/