SQL Server nText Memo Field With Access Form
am 17.04.2008 22:20:14 von consulttech2004Hello! We are using Access 2000, SQL Server 2000. We are using a
simple append query to append data from an unbound form field to an
SQL Server linked table. The field in Access is a memo field, and in
SQL Server it is an nText field. However, some of the text gets
garbled at the end of long entries (approx. 510 characters.) An
example of this follows:
The quick brown fox jumps over the lazy dog. The quÂÄ«ÌÕ=
¤á´ì à»ÄÂĬ Ìî=B8=
à»=B9
Is this a product of the linkage? Should I use a different SQL Server
field? Any other recommendations? Thanks!