Record Is Deleted (Error 3167)

[Tyler]

It appears that one record in a table of about 5000
records is corrupt. I cannot repair the database or
delete the record. Any way to recover from this?

Thank you,
Tyler

 

[James Goodman]

Have you tried importing the table into a new DB file?

 

[Van T. Dinh]

IIRC, Tony Toews has instruction on how to remove a corrupted Record. See
his article on corruptions and other materials mentioned in his article:

http://www.granite.ab.ca/access/corruptmdbs.htm

 

[Tony Toews]

IIRC, Tony Toews has instruction on how to remove a corrupted Record.

Ayup.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm