Corrupt File, Help with possible solution

[kcapehorn]

We have an Access file that we believe is corrupt. The Access file contains one table with 21 records and one form that shows all the fields in the table. We can open the file, but when we open the table, Access crashes instantly (it says Access has to close and do we want to send an error report, no error message more descriptive than that I'm afraid). A box then opens asking if we want to make a backup of the database - if we try this, Access crashes again in the same way.

If we open the form, we can view the all of the records up to the 20th record. If we try to move on to the 21st record, Access crashes, so the 21st record is probably corrupt.

I have found that if I go into the design of the table and delete one of the rows, Access will not crash and I can view the table and form in full. The row I have to delete is formatted as an OLE Object, so perhaps someone has put bad data into this field on the 21st record.

Is there a way to fix this problem without having to delete the entire row? I am perfectly happy to delete the 21st record, but would rather not delete the row. Could we come up with a clever macro or module that will delete the 21st record?

Thank You.

 

[Atomic Shrimp]

Have you tried creating a new empty database and importing the table into it?

 

[gemma-the-husky]

if there are only 21 rows, and only 1 corrupt row, I don't understand what would be the problem with re-entering the corrupt row.

the probelm certainly indicates corruption - and its best fixed before it gets worse. make sure you are using a split database, if you have multiple users accesssing the dbs.