Error: "Record is too large." when exporting to Access

Access limits the total number of characters that can be saved in a single record to 2000.

If you receive this error, there are several possible solutions:
  • Change some of the fields that contain the largest number of characters to the Memo type. Memo type fields don't count their whole content toward the 2000 character total.
  • Normalize the table into more than one table and execute more than one SQL statement in Sync & Save to insert the data into more than one table.


http://answers.microsoft.com/en-us/office/forum/office_2013_release-access/record-is-too-large/cf4951bc-79a4-4206-be9d-7663462d4782
http://office.microsoft.com/en-us/access-help/access-2010-specifications-HA010341462.aspx

Feedback and Knowledge Base