pesty Deleted record

[chad]

I have a deleted record in my main table that won't go
away. It just says "deleted" in every field of that
record's row in my table. Its making it so any query or
report that includes that record doesn't work. I just get
error message # 3167 "REcord Deleted." I've tried
deleting it many times off the main table, but it won't go
away. Help!

 

[John Vinson]

I have a deleted record in my main table that won't go
away. It just says "deleted" in every field of that
record's row in my table. Its making it so any query or
report that includes that record doesn't work. I just get
error message # 3167 "REcord Deleted." I've tried
deleting it many times off the main table, but it won't go
away. Help!

Is this a linked table or is it local to this database? Have you tried
Compacting the database?

 

[Tony Toews]

I have a deleted record in my main table that won't go
away. It just says "deleted" in every field of that
record's row in my table. Its making it so any query or
report that includes that record doesn't work. I just get
error message # 3167 "REcord Deleted." I've tried
deleting it many times off the main table, but it won't go
away.

This is a corrupt record. See the Damaged records within tables
section at the To retrieve your data from a Corrupt Microsoft Access
MDB page at my website.

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