Error: "Record is too large." when exporting to Access
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