[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 understand what you are saying.  Now the question becomes, how can I 
determine how many ASCII characters are being returned?  When I try using 
LEN(<<Field Name>>) in A2K it returns 255.  I have not tried it using the 
Query Analyzer in SQL Server yet.




"Heenan, Lambert" <Lambert.Heenan at AIG.com>
Sent by: accessd-bounces at databaseadvisors.com
06/30/2003 12:08 PM
Please respond to "Access Developers discussion and problem solving" 

 
        To:     "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
        cc: 
        Subject:        RE: [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 >> 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030630/c175fcfb/attachment-0001.html>