Corrupt Forms

[tt08234]

I have database with 15 forms. 2 out of the 15 forms are the most heavily
used and somewhat more complex than the other forms. Every so often when I
use the forms or go into the design view and make changes, the forms seem to
dissapper but are sill listed in the Database Window. Sometimes, compacting
and repairing reinstates the forms. However, other times the forms can
neither be opened nor designed after compact and repair.

I used the 'Saveastext' and respectively 'Loadfromtext' functions to copy all
the forms, queries, reports and modules from a backup copy of the database to
a new database and imported the tables to solve the problem. However, the
problem is still popping after continued design or repetitive use of the two
forms.

Any help would be appreciated. I know I can copy over the controls from the
suspect forms to blank forms, but wanted to avoid that because it seemed
easier do use the 'Saveastext' and 'Loadfromtext'

 

[Linq Adams via AccessMonster.com]

Since this is a chronic problem for you, you might want to read Allen
Browne's treatise on the causes and methods of preventing corruption:

http://allenbrowne.com/ser-25.html

 

[Linq Adams via AccessMonster.com]

Sorry, meant to add, the page also has a link to Allen's paper on recovering
from corruption.

 

[tt08234]

Sorry, meant to add, the page also has a link to Allen's paper on recovering
from corruption.
Thank You, I will take a look.