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

  • Thread starter Thread starter jj
  • Start date Start date
J

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
 
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.
 
Back
Top