Where are the experts ..... ?

[ctudose]

Scenario - Access97/Access2000:

I've created a table with one field type MEMO;I upsized the table to SQL Server 2000 using DTS ;
The field went to ntext(16) by default, which is correct though;
I linked back the table to Access 97/2000 through ODBC (User DSN) and ... the field is NOW type Text(255)
I've tried also with text, nvarchar... same result

Question : Is there any experts out there to give a solution/sugestion ??

THANKS IN ADVANCE

 

[AnnYH]

Hi, Cris:

Sorry, yesterday I didn't read your post carefully.

I tried in mine. When I linked the table using Access 97. The Memo change to Text(255). If you link the same table using Access 2000, it will show the fields Memo.

If frontend is Access 2000. the link table still show the fields text(255). So what's your OS 2000, 98? Check you ODBC version. Update newest version for your ODBC connection.

I'm not pretty sure it can be help. But try this way. See what will be happen.

Good luck.

Ann.