Resolve ODBC / SQL Server issues with NVARCHAR(MAX) and REAL
Several SQL Server / ODBC data types poorly supported. I have just found that NVARCHAR(MAX) is the recommended SQL Server memo field type but Access is inconsistent in handling this - text larger than 4000 characters fails to update.
Ananda Sim commented
I spotted a similar topic here: