one corrupt line in database; cannot be deleted.

  • Thread starter Thread starter Charles Rooney
  • Start date Start date
C

Charles Rooney

One entry (of 1738)appears to be corrupt. (Error message
below.) I cannot delete it. What can I do to get rid
of it? Will it damage the entire file, which works so far.

Microsoft Jet Error Message: Reserved error <Item>; there
is no message for this error. (Error 3000)
 
Yes it could damage the file.

To fix it, I would build a copy of the database,
move all tables to the new one except this table.

Then write queries to move every record except the damaged one.
The re-build the damaged record by hand.
Delete the old mdb (weeks after verifying the new one works.)
 
Back
Top