Can't open form in design mode

[Mark Andrews]

I have an Access2003 database that got in a bad state. One particular form
I cannot do the following:
- open the form (design view or normal)

I tried:
- compact/repair the database (TWICE)
- import all tables, queries, forms etc... into a new database (problem form
does not come over)
- decompile the database
- tried this SaveAsText acForm, "Form1", "C:\MyFolder\Form1.txt"
using my formname etc... (this gave me a "problem send to Microsoft
error...")


Any tips or advice?
Mark

 

[Tom van Stiphout]

On Sat, 26 Sep 2009 10:11:17 -0400, "Mark Andrews"

If you have the database split per best practices, you can simply
replace the front-end.

-Tom.
Microsoft Access MVP

 

[Mark Andrews]

I guess I didn't mention that I was in the process of developing the
front-end.

Yes the database is split and the form is in the front-end. Unfortunately,
I was in the process of developing
the front-end when I hit this issue. I have a backup that's about 5 hours
old but this form is the most complicated one in the mix (many sub-forms,
and a fair amount of code right in the controls (some DSUMS etc...)). One
of the subforms also got locked up.

Luckily I could get to the code behind, I ended up just re-doing my work,
however it took about an hour.

I hit a "there is not enough memory to perform this operation" when I tried
to save the form and then it locked and I had to ctrl/alt/delete. I
actually got another one of these errors after I did the following:
- created new database
- moved all queries, forms etc... to new database
- moved problem forms from my old backup (before it was a problem) to new
database
- did another 5 hours work and hit this error again
Luckily this time I didn't lose the forms.

I guess I'll start backing up every hour.

I haven't seen that error before, wondering if I have some kind of
corruption in the mix?

Any help is appreciated,
Thanks,
Mark