SQL Server nText Memo Field With Access Form

SQL Server nText Memo Field With Access Form

am 17.04.2008 22:20:14 von consulttech2004

Hello! 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!