WONT DELETE

[Cant Delete Record]

I cannot delete one particular record. I get the window
that pops up and says are you sure that you want to
delete and I click yes, the record deleted window
appears , the record appears to go away but the minute
that I close the table then reopen it the dang thing is
back!!!!!!!!!!!!!!!!!!!!!!! HELP PLEASE - I CANT TAKE IT
ANYMORE!


From origional on 2/26/2004

No error message, It appears to go away but the moment
that you close the table or form and then reopen it, the
darn record is back!

 

[mikepage5]

I found out why the record would not delete but not why
it occured.

A record in a related corresponding table had #DELETED in
every field including the Primary key. I exported all
records then imported them into a copy of the origional
table then replaced the origional with the copy.

But why did this happen and how can it be prevented.

 

[John Vinson]

I cannot delete one particular record. I get the window
that pops up and says are you sure that you want to
delete and I click yes, the record deleted window
appears , the record appears to go away but the minute
that I close the table then reopen it the dang thing is
back!!!!!!!!!!!!!!!!!!!!!!! HELP PLEASE - I CANT TAKE IT
ANYMORE!

You may have a corrupt Index or some systems table corruption.

Try creating a brand-new .mdb file. Use File... Get External Data...
Import to import everything EXCEPT this table. Create the table,
*empty*, in the new database.

Then use File... Get External Data... Link to link to the table in the
old database. Run an Append query to append all *but* this record.

 

[John Vinson]

I found out why the record would not delete but not why
it occured.

A record in a related corresponding table had #DELETED in
every field including the Primary key. I exported all
records then imported them into a copy of the origional
table then replaced the origional with the copy.

But why did this happen and how can it be prevented.

Sorry - posted a reply in your other thread before I saw this!

My suspicion was correct; this is a symptom of a damaged index or of
systems table corruption.