phantom form haunting database

[Guest]

I have corrupted a database, possibly by deleting a form when I shouldn't
have. I had a somewhat similar problem when I deleted a table before first
deleting its relationship to another table. But I don't know how to get out
of this one.

When I open the database, the message appears "An error occurred while
opening 'form_old'. Do you want to continue loading the project?" When I
click Yes, I get:
"The form name 'form_old' is misspelled or refers to a form that doesn't
exist." When I click OK, I get the same message -- a total of 5 times. Then
the database opens.

When I started having this problem, I tried to import the deleted form back
from another database, but the imported form kept disappearing from the list
of forms. However, the name of the deleted form still appears in VBA, in the
list of forms. If I click on it there, I get the same "The form name
'form_old' is misspelled or refers to a form that doesn't exist" -- twice.

I have tried database compact and repair. I do not have Name Autocorrect
turned on, if that makes any difference. Could anyone tell me the cause of
and solution for this problem, please?

 

[Guest]

You say when you import the form it disapears.
Try with a new database and import. Then import everything else.

 

[Guest]

Thank you for your suggestion, Karl. Although the database contains 65
tables, 173 queries, 20 forms, and 60 reports, I guess I could try importing
them all into a new database. I am hoping however that this problem has a
known cause and remedy. Additional ideas?

 

[Guest]

You can try using the Documentor. Click on TOOLS - Analyze - Documentor.
Select all queries and option of SQL. Run and output to MS Word by clicking
on the Word icon on the tool bar. Do a word/ phrase search for the items
mentioned in the error messages.
Do the same for the forms, reports, etc.

 

[MacDermott]

It's pretty quick to import everything, using the SELECT ALL button on each
tab.
Don't forget to import your relationships (and toolbars, if you have custom
ones) too.