one corrupt line in database; cannot be deleted.

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)
 
J

Joe Fallon

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.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Corrupted 97 DB, No Objects displayed? 3
How to recover SQL server database from corrupt mdf file? 3
Excel Excel cannot open .xls file 0
Repairing a corrupt registry 9
Word Removing unwanted "lines" within a MS Word 10 table 1
3011 Jet Database Error Message and others 1
Removing unwanted "lines" within a MS Word 10 table 2
Run-time error '3000 ': Reserved Error (-3201); there is no message for this error. 0

Top