ERROR: The field is too small to accept the amount of data you attempted to add.

I generally work with Microsoft SQL database. This time I got into a situation when I have to work with Microsoft Access. I did very little work with Access before, so I was concerned at the begining.  Later as I started working I found it's not that difficult, lot of syntax matches with MS SQL with some differences of course.

Anyways when I was working with a situation when I had to insert big text into the Access table I got the error "The field is too small to accept the amount of data you attempted to add. " After looking at the helps I found its max limit is 255 characters. You can change the max limit with Field Size property. In my case this field size would not work, since I have to insert big chunk of text. Then I found if you change the field type as Memo it can take upto 63,999 characters which works for me. One problem is Memo data types can not be indexed for performance. If you ever got into this error, you know the solution now.