Memo fields are more prone to corruption because they are not actually
stored in the same table, just a pointer to them. Very often, just the memo
is corrupt, not the entire record. If you go in the table, you can sometimes
delete just the memo field data.

Most corruption is caused by either users inappropriately turning off their
computer or by a bad network card. Corruption can also be cause by not
having a split database if there are multiple users.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"JamesJ" wrote in message
...
Access 2007 sp2.
I have a rich text memo field in a table with 2 other fields.
Sometimes when I make changes to the memo field I am told that
access can't update the record because it is being "used by another user"
Not sure of the entire error message but I'll get it because it will
happen again.

From that point on I am unable to make changes the that record. I must
delete the record and create a new one.

Is any one else having this problem?

Must be some limit to something in the rich text memo fields.

James