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

Well I count 258 characters in the data, so the error message is totally on
the mark (odd for Access<g>).

I suspect that SQL server is passing back all 258 ASCII characters, which is
why A97 chokes. But A2K is Unicode character savvy, so I think it can handle
510 ASCII characters, or 255 Unicode ones.

Lambert

> -----Original Message-----
> From:	jeffrey.demulling at usbank.com [SMTP:jeffrey.demulling at usbank.com]
> Sent:	Monday, June 30, 2003 12:59 PM
> To:	accessd at databaseadvisors.com
> Subject:	[AccessD] Error Message: The field is to small to accept the
> amount of data you tried to add. Try inserting or pasting less data
> 
> 
> 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 
>  << File: ATT8947467.txt >>