I upsized a dbase from Access to MS SQL Server 7, and everything seems to go fine, except for one annoying issue:

When I try to display the contents of a field which used to be of the type memo in Access, I get this error:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

when I try to read out the contents of the field in the SQL Server table.

Even when I make a simple page that only shows the content of the field on screen, I get that error.

In SQL Server the field type is ntext (length 16). I've changed it to text (length 16) but that doesn't change anything.

What am I missing here? Why can't I display the contents of that field?

try changing it to a varchar with a size of something bigger, like 20

if you are still getting that error message, I would:
-create a new table and set up all of the datatypes and indexes in SQL server
-import the data into the new table.
-drop the old table.
-rename the new one to the correct name.

hope that helps,
Joel Martinez

----------
Is this thing on?....