Access2000 Compact and Repair

  • Thread starter Thread starter a_h
  • Start date Start date
A

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 ?
 
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 ?
Click to expand...

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
 
Back
Top