can not open form

[eapinto]

Hi,

I Cannot open my form (frmMAIN1). I have 3 sub forms taht are associated with them. First it gave me a out of memory error. I did try to fix it but it didn't work so, I created another form from scratch. Well, when I created the form It worked until I had to go and put a couple of additional fields in one of the sub forms tables. I did this by closing the main form along with the subforms. hten I opened the table and created the fields I wanted. I closed the table.(tblMIV1). I then opened the subform (frmMIV1) but it didnot let meopen to add the fields I had put on the table. I can not open the main Form either.

I have tried the compact and repair features to no avail.

Please help if I have a corrupted piece of data, how would I go about discovering what it is?

Any help would be wonderfull as I have put about two months worth on this project.

Thanks,

EVert

 

[aqif]

Best way to find which objects is to create a new blank database and then import all objects from the "suspected corrupt" db. After importing objects open any form in code view and goto Debug-->Compile and finally compact and repair the database.

Whole thing will take 5 mins. Worth a shot