#Delete appear in field

[TS Lim]

In my application, I not sure what I have done, sometime the memo field of a
record has the the word #Delete. After that, this particular report cannot be
edited any more. Kindly advise what are the possible causes for this.

Thank you.

 

[Allen Browne]

This can indicate that the record is corrupt.

See the suggestion under "Symptom: Some table rows show #Deleted" in this
article:
http://allenbrowne.com/ser-47.html#RowsShowDeleted

 

[John W. Vinson]

In my application, I not sure what I have done, sometime the memo field of a
record has the the word #Delete. After that, this particular report cannot be
edited any more. Kindly advise what are the possible causes for this.

Thank you.

#Deleted# will appear in a textbox when the record being displayed has been
deleted from the table (and the form has not been requeried). The record
cannot be edited because it does not exist any more.

 

[TS Lim]

Mr Allen Browne,

In my case, I have a number of fields including a memo field, the #Deleted
appear in the memo field, the othe fields are ok. Does that mean the record
is deleted. If not can I repair this record ?

Please advise. Thank you.

TS Lim

 

[Allen Browne]

Yes: this is a symptom of corruption.

Access doesn't store large data fields (Memo, OLE Objects, etc) in-line with
the data, but stores a pointer to where they are stored. The #Deleted in the
memo field indicates that the pointer to the memo field data is corrupt,
even though the rest of the record is okay.

If you have several memo fields like that, you may want to track down the
cause. Access 97 had a problem like that, but it was fixed in the service
packs so make sure you have SP2 and the JET3.5x service packs applied. The
links are:
http://www.microsoft.com/downloads/...42-602e-42b0-89d2-6be39f1167c1&DisplayLang=en
and:
http://support.microsoft.com/kb/172733

For later versions, or if you already have those SPs for A97, these
suggestions might help prevent corruption:
http://allenbrowne.com/ser-25.html