Why Can't I Open Several Forms in an Access 2003 .mdb file?
Posted on 2009-02-21
I cannot open several forms in Form View or Design View in my .mdb file. In fact, I imported these forms from many other .mdb files and I can't open them even if I rename them. Some forms do have subforms and I can open the subforms in Form View and Design View. The forms have embedded queries and external ones too. The queries and tables work.
Here is what I CAN do:
1. Export all objects into a new .mdb file and then compile and compact & repair (CCR): Forms will still not open.
3. Export it to a new .mdb file, CCR, and re-import it and CCR: Cannot open the forms in either file.
4. View the code behind the forms (I open another object in design view and search for a word that is in the form I can't open): I can copy all the code and save it in a txt file. But when I try to paste it back into the form, Access closes.
1. Copy and Paste a form into the same .mdb file. I get error: "The Microsoft Jet database engine could not find the object '[what ever I named the form]". Make sure the object exists and that you spell its name and path name correctly.