Skip to content

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.

Feedback and Knowledge Base