In my table with memo filed, the fields is fill with "#Delete", not key-in
by me, and the record cannot be edited. It seems that the record is
corrupted. Can anybody advise under what circumstances this corrruption can
occur, so that I will try to avoid it form happening
--
TS Lim

Corruption is a huge subject to cover in a forum post.

A great resource to get started on the learning process is
http://www.granite.ab.ca/access/corruptmdbs.htm

go down to the 'more info' and 'links' sections.

Also, make sure you perform routine backup of your database, just in case!
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.



"TS Lim" wrote:

> In my table with memo filed, the fields is fill with "#Delete", not key-in
> by me, and the record cannot be edited. It seems that the record is
> corrupted. Can anybody advise under what circumstances this corrruption can
> occur, so that I will try to avoid it form happening
> --
> TS Lim

Details on how to rebuild this table:
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:91EE4045-F61D-4607-8A5E-(E-Mail Removed)...
> In my table with memo filed, the fields is fill with "#Delete", not key-in
> by me, and the record cannot be edited. It seems that the record is
> corrupted. Can anybody advise under what circumstances this corrruption
> can
> occur, so that I will try to avoid it form happening
> --
> TS Lim

Try compact and Repair and . . . cross your fingers.

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Daniel Pineault" wrote:

> Corruption is a huge subject to cover in a forum post.
>
> A great resource to get started on the learning process is
> http://www.granite.ab.ca/access/corruptmdbs.htm
>
> go down to the 'more info' and 'links' sections.
>
> Also, make sure you perform routine backup of your database, just in case!
> --
> Hope this helps,
>
> Daniel Pineault
> http://www.cardaconsultants.com/
> For Access Tips and Examples: http://www.devhut.net
> Please rate this post using the vote buttons if it was helpful.
>
>
>
> "TS Lim" wrote:
>
> > In my table with memo filed, the fields is fill with "#Delete", not key-in
> > by me, and the record cannot be edited. It seems that the record is
> > corrupted. Can anybody advise under what circumstances this corrruption can
> > occur, so that I will try to avoid it form happening
> > --
> > TS Lim