corrupted record

[Andy Calder]

I have an Access Database that is set up as a split
database ( back end tables on network and front end on
each users machine). Recently we had a record corrupt (
#Error on memo field and other fields has jibberish). I
tried to repair but it won't repair. i tried to delete it
but it won't delete.

Are there any other repair utilities i can use to delete
this corrupted record?

 

[Daran Johnson]

Andy,

I would move all the data (except the corrupted portion) into another
database file and delete the original. Once the file has been corrupted it
is best not to use it any more. Another option is to restore from a backup
prior to the corruption.

Daran

 

[John Vinson]

I have an Access Database that is set up as a split
database ( back end tables on network and front end on
each users machine). Recently we had a record corrupt (
#Error on memo field and other fields has jibberish). I
tried to repair but it won't repair. i tried to delete it
but it won't delete.

Are there any other repair utilities i can use to delete
this corrupted record?

This is a pretty common problem with Memo fields, and it's rather
tedious to fix. See http://www.granite.ab.ca/access/corruptmdbs.htm
for details.

To fix this you'll need to do it yourself. Create a new, emtpy mdb
file; use File... Get External Data... Import to import everything BUT
this table. Import this table separtely, *design only* - if you import
the contents of the table you'll corrupt the new database too!

Now use File... Get External Data... Link to link to the table; write
one or more Append queries to append all the non-damaged records. Use
ranges on the Primary Key to avoid Access having to actually open
records on the table; i.e. if the PK is Autonumber and it's the record
with ID equal to 1234 that's damaged, use a criterion of

ID < 1234 OR ID > 1234

Run the query; recheck your relationships; recompile the database and
compact it, then junk the old damaged database.