Append Query/Memo Truncation

[martinjeffreys]

Hello

I'm using an append query from an Access front end to add data to a back-end
SQL table. It all works OK - except a Memo field is being truncated to
765(ish) characters.

Any thoughts gratefully received

Martin J
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.714 / Virus Database: 470 - Release Date: 02/07/2004

[Bruce Dodds]

martinjeffreys wrote:

Hello

I'm using an append query from an Access front end to add data to a back-end
SQL table. It all works OK - except a Memo field is being truncated to
765(ish) characters.

Any thoughts gratefully received

Martin J
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.714 / Virus Database: 470 - Release Date: 02/07/2004

I don't know why you're having this problem. However, you might have a
better chance at getting a good response if you said what back-end SQL
product and what version of Access you're using. You also might try
posting on a newsgroup for the SQL product. Good luck.

[dixie]

Martin, try taking out the Totals line in the query if it is there. This
worked for me.

dixie

"martinjeffreys" <ma************@btinternet.com> wrote in message
news:cc**********@sparta.btinternet.com...

Hello

I'm using an append query from an Access front end to add data to a back-end SQL table. It all works OK - except a Memo field is being truncated to
765(ish) characters.

Any thoughts gratefully received

Martin J
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.714 / Virus Database: 470 - Release Date: 02/07/2004