I am upgrading an ACCESS 2007 backend database to a SQL 2008 database. Several fields are memo fields in the Access backend and they converted to nvarchar(max) on the SQL db. There a many records that have data lengths of more than 10,000 characters in these fields. I read that those fields in SQL should actually be text so I changed them to text. The issue is that when editing one of these large fields I can read it into an access 2007 form but when I try to save it (when over 8000 characters) I get an error -- ODBC--call failed. [Microsoft][SQL Server Native Client 10.0]String data, right truncation (#0) -- any ideas?