CHALLENGING Q : Is MEMO field through ODBC an issue on ACCESS 97 ??

[ctudose]

I have a table in Access 97(100+ fields) and one of the field is type "MEMO"
I upsized the table to SQL Server 2000 using DTS.
The correspondent field on SQL is type "ntext(16)" which is correct.
I linked back the table in Access 97 through ODBC.
In design view(Access 97) the field is now type TEXT - Size : 255 ... why is like that ?
I use a form to update/display all the records on SQL.
The information in this particular field(remember that original was MEMO) is now truncated to whatever is after the 255th character(is the length is < 255 , it's ok)
If i want to add a new recored, i am allowed to type in max 255 chars.
HOW I CAN PRESERVE A FIELD TYPE MEMO THROUGH ODBC ?

Any suggestion would be much,much appreciated
Thx,
Cris

 

[QatQat]

The correct datatype for MEMO in SQL server is 'text'.

The ntext datatyppe instead is used to store unicode data and stores a double byte per stored character.

With 'text' you are allowed to write anything up to 16kbytes of text.


Bye


Qatqat

 

[ctudose]

Hi Qatqat,

I've tried also text on SQL ,but using this type I've got an error message : ODBC--called failed when I open the linked table in Access and #Name? in all records.
If I use ntext there is no error message , but I'm restricted to Text(255)
Any further suggestion ?

Regards,
Criss