pesty Deleted record

  • Thread starter Thread starter chad
  • Start date Start date
C

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

Is this a linked table or is it local to this database? Have you tried
Compacting the database?
 
chad said:
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.
Click to expand...

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