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