This is an inherent deficiency of Access. This error occurs because there is an error in your Access database.
First use Ms Access to compress and repair, and then go to the relevant table to remove the index in the memo type field.
Why can't the memo field exceed 1950 bytes? This is because the memo field is indexed. When using Access to design the database table, click Design View->Index, and you can see that this field has an index. For this reason, nothing will happen if you delete this index.
The strange thing is: when designing the table in ACCESS, there is no option to add an index function to the memo field in the memo field.
This article comes from KinJAVA log (http://jorkin.reallydo.com)
Original address: http://jorkin.reallydo.com/article.asp?id=516