[AccessD] Error Message: The field is to small to accept the amount of data you tried to add. Try inserting or pasting less data

jeffrey.demulling at usbank.com jeffrey.demulling at usbank.com
Mon Jun 30 11:58:33 CDT 2003


I am getting the above message in an A97 FE connecting to a SQL Server BE.
I do not get the error message when using A2K FE (both version of app have
the same code.)


This I found the record that is causing the problem along with the field.
Once I remove the field from my pass-through query in A97 the results are
returned.  If I leave the problem field in the query I get the message
above.


The data in the field is:



12/2/02-TR rejected review needs documents and completed Master Initial
Account Review Checklist.  E-mail sent to Mike Herberger to notify him.
BJQ.  12/19/02-AM review done date removed due to TR rejection.  BJQ. Sent
IR checklist to Barbara. 1/8/03 MH


The field on the BE is a nvarchar (255).  Any ideas or helpful suggestions
would be nice.

TIA
-Jeff
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030630/33f6f555/attachment.html>


More information about the AccessD mailing list