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.

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"TS Lim" <(E-Mail Removed)> wrote in message
news:CBFD6C3C-0D4D-4CDC-9F92-(E-Mail Removed)...
> 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.

On Wed, 31 Mar 2010 21:48:01 -0700, TS Lim <(E-Mail Removed)>
wrote:

>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.
--

John W. Vinson [MVP]

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" wrote:

> 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
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
>
> "TS Lim" <(E-Mail Removed)> wrote in message
> news:CBFD6C3C-0D4D-4CDC-9F92-(E-Mail Removed)...
> > 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.
>
> .
>

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/d...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

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"TS Lim" <(E-Mail Removed)> wrote in message
news:3515C182-8BE8-4EA5-A639-(E-Mail Removed)...
> 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" wrote:
>
>> 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
>>
>> --
>> Allen Browne - Microsoft MVP. Perth, Western Australia
>> Tips for Access users - http://allenbrowne.com/tips.html
>> Reply to group, rather than allenbrowne at mvps dot org.
>>
>>
>> "TS Lim" <(E-Mail Removed)> wrote in message
>> news:CBFD6C3C-0D4D-4CDC-9F92-(E-Mail Removed)...
>> > 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.
>>
>> .
>>