Access2000 Compact and Repair

[a_h]

I have problem when tryin to use Compact and Repair on a
DB with the size of 80 Mb. When looking on one of the
table I see a record that all of its fields having "#####"
in it. I cant delete this record and can't compct the DB.
Is someone know of such problem and any solution ?

 

[John Vinson]

I have problem when tryin to use Compact and Repair on a
DB with the size of 80 Mb. When looking on one of the
table I see a record that all of its fields having "#####"
in it. I cant delete this record and can't compct the DB.
Is someone know of such problem and any solution ?

This is not an uncommon problem: often (but not always) it's because
of a corrupt memo field in the record. It's a bit of work to recover:

- Create a new, empty database
- Use File... Get External Data... Import to import everything EXCEPT
this table
- Import this table *design view only*
- Use File... Get External Data... Link to link to the old table
- Run an Append query using criteria on the Primary Key to import all
the records *except* this one
- Manually reenter the damaged record (if you can externally determine
what it contained)
- Compact the new database and use it in place of the old one