Corrupt Form

[Guest]

MS Access 2003 SP2

MDB file

The Record Source of my form is a SQL table. The form has 174 textboxes.
Each textbox is bound to a column in the SQL table. The form has a filter
and an Order By. Navigation Buttons are set to Yes.

When the form is opened the user can navigate through the rows in the table
with the navigation buttons.

This form suddenly disconnected from the SQL table. No record appears when
the form is opened. All the other forms in the mdb remain connected to their
Record Sources.

I have tried:

Compact and Repair

I changed the Record Source to a query that includes all the columns of the
table.

I opened another mdb file and imported the form into this file. Then I
imported the form back into the original mdb.

The form still remains disconnected from the table.

I do not believe that a user accidentally opened the form in Design Mode and
made a change.


I can open a new form and copy and paste all the text boxes from the
original form. I set the Record Source, Filter, and Order By to agree with
the original form. The new form connects to the table and behaves normally.
We also keep a backup of this mdb and the form in the backup is connected to
the Record Source so recovery was not an issue.


I would just like to know what happened to this form?

Thanks,

Wayne

 

[Arvin Meyer [MVP]]

First, always work on a copy of the database. Working on the original may
make it impossible for a repair service to fix it.

Download a copy of JetComp.exe:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956

Try backing up your forms as text with the undocumented SaveAsText
LoadFromText functions:

http://www.datastrat.com/Code/DocDatabase.txt

Also have a look at the Microsoft KB article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137

Then have a look at Tony Toews' Access Corruption FAQ at:

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

for some suggestions. Unfortunately, some corruption cannot be fixed - you
may need to create a new database, import what can be salvaged, and recreate
the rest.

Although it's a paid service, Peter Miller does an outstanding job of saving
corrupt databases. Try this URL:

http://www.pksolutions.com

 

[Guest]

I will try your suggestions.

Thank you very much Arvin,

Wayne