Problem linking Access97 --> SQL SERVER containing NTEXT fields

[ctudose]

I have a table in SQL Server 2000 that has a field in it of type "ntext". When I try to open the linked table through ODBC using Access97 all that appears for each field in some of the rows is "#Name?" and the error message
ODBC-call failed(error 3146)
Design view of the linked table in Access shows that the "ntext" field in SQL Server was mapped as a "Memo" - which is correct, though

If I change the data type on SQL Server 2000 to "nvarchar", I can open now the linked table in Access 97 without error, and the field is mapped as "Text"-correct


Originally my table was upsized to SQL Server 2000 from Access97.
The field was converted automatically from "MEMO" to "NTEXT" during this process.

What I really need is to have that field of type ntext on SQL Server(Memo in Access 97), otherwise the information is truncated

Any advice would be much appreciated.
Thanks,
Cris