Form Cannot be Opened, Opened in Design View, or Imported

[Guest]

Hello,

MS Access 2003 SP2

I have a form in an mdb file. The form is based on a query. The query can
be run. The tables are MS SQL Server. All tables appear normal and can be
opened.

I cannot Open this form. I cannot open this form in Design View. I cannot
Import this form into another mdb file.

Any suggestions on how to open this form? Any idea on how it became
corrupted?

Thanks.

 

[John Vinson]

Hello,

MS Access 2003 SP2

I have a form in an mdb file. The form is based on a query. The query can
be run. The tables are MS SQL Server. All tables appear normal and can be
opened.

I cannot Open this form. I cannot open this form in Design View. I cannot
Import this form into another mdb file.

Any suggestions on how to open this form? Any idea on how it became
corrupted?

Thanks.

It may be junk at this point - and your entire .mdb file should be
considered suspect. Check out

http://www.granite.ab.ca/access/corruptmdbs.htm

for suggestions; but you may want to play it safe, create a new empty
..mdb, and import everything except this form. Recreate the form from
scratch (or from an old backup where it still works).

John W. Vinson[MVP]

 

[Guest]

Thanks John.

Yes, the form is too far gone. I tried the suggestion about saving the form
as text. MS Access crashed when I tried this.

I was able to recreate the form as it was very simple and based on one table.

That was a very helpful link you posted.

Thanks again.

Wayne