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
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