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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The field is toosmall to accept the amount ofdata you attempted to 2
VBA - retrieve data on last create named range from previous inserted named range 0
The Field is too small to accept the amount of data you attempted 3
"field too small to accept amount of data you attempted to add" er 2
INSERT into Access Database using C# from ASP page 5
Cannon insert large values in Access memo field 2
3163 The field is too small to accept the amount of data 1
ACCESS MAKE-TABLE QUERY "BUG"(?) 3

Back
Top