Append query - memo truncated to 765 characters

[Martin Jeffreys]

Hello
I'm using an append query to save data from an Access
front end to SQL. It's all working OK - except a
memo/ntext field is being truncated to 765(ish) characters?

Any suggestions greatfully received

Martin J

 

[Jeff Boyce]

Martin

Consider posting your SQL statement...

 

[Martin Jeffreys]

-----Original Message-----

Martin

Consider posting your SQL statement...

--
More info, please ...

Jeff Boyce
<Access MVP>
.

OK
It's an Access 2002 Front End (mdb) - the user is making
notes while talking to customer - during which the Note is
held in a 1 row local table [Parameters] as a memo field
[dummy_memo].

When the user presses a save button the new note is
appended to a backend [Notes tbl] - Microsoft SQL Server
2000.

All works fine - except as I said before large notes are
truncated to 756 ish (512 + 255)???

SQL statement:-

INSERT INTO [Notes tbl] ( [Hube Account No], [By Whom],
[Date], TyprofQry, Notes )
SELECT Nz([Forms]![frm Customer Details (Section 1)]![Hube
Account No],[Forms]![frm Customer Details (Section 1)]!
[Contract No]) AS Expr1, get_user() AS Expr2, Now() AS
Expr3, Parameters.dummy_qry_type, Parameters.dummy_memo
FROM [Parameters];

The Note is there in full in [Parameters] - direct input
to the back end allows any size note.

Thanks in advance

Martin Jeffreys

 

[Jeff Boyce]

Martin

Nothing jumps out at me, but maybe other 'group readers will spot something.

Have you also posted to the SQL Server 'groups?