LINKED TABLE - WRONG FIELD TYPE - HELP !!!

[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.
The correspondent field on SQL is type "ntext" 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

 

[AnnYH]

Hi, Cris:

Microsoft is not that smart enough. After you upsize your access to SQL. You must go into the SQL database check the data type and default value. In my case I changed the memo to ntext.

A lot of small things you need take care, after you upsized the access.
Hope it is can help you.

Ann

 

[ctudose]

Hi Ann,

I've tried different version: by default it goes to ntext(16) as I specified before
I've also tried with text, nvarchar...
Same result:
-on the design view of the linked table the field is Text(255)
So does anybody now if there is a solution for this issue ???

Cris