The field is too small to accept the amount of data you attempted to add. Try inserting or pasting l

[jj]

I am trying to insert data into an "access" table programmatically.
Sometimes I get the following message:

"The field is too small to accept the amount of data you attempted to add.
Try inserting or pasting less data."

I believe it is not the field size, it has to do with the amount of data
access table can handle. Does "access" has limitations of data size?.

Any idea??????

JJ

 

[diesel]

Yes. Open the db in Access and open the table in design view. There
is a Field Size property for any text fields. I believe the max is 255
for a text field. If you need more than that, use the Memo datatype.