Solution to "search keywords not found in all records in an Access database" Application tips

Use Ms Access to compress the repair and then go to the related table to remove the "index" from the Memo Type field
Why can't a Memo field exceed 1950 bytes? is because the Memo field has an index. When you design a table for a database using Access, click the Design view-> index, and you can see that the field is indexed. That's why, by deleting this index, nothing is going to happen.
The weird thing is that when you design a table in a Memo field, there's no option to index the Memo field at all.
This article originates from Kinjava log (http://jorkin.reallydo.com)
Original address: http://jorkin.reallydo.com/article.asp?id=516