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]

Re: Append Query/Memo Truncation

martinjeffreys wrote:
[color=blue]
> 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
>
>[/color]
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]

Re: Append Query/Memo Truncation

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

dixie

"martinjeffreys " <martinjeffreys @btinternet.com > wrote in message
news:ccc6gp$i6d $1@sparta.btint ernet.com...[color=blue]
> Hello
>
> I'm using an append query from an Access front end to add data to a[/color]
back-end[color=blue]
> 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
>
>[/color]