VERIFIED SOLUTION i

Resolve the error in MapInfo 15.2 64-bit and later when saving a query :"Error writing File size exceeds maximum of 2097152K.. object not inserted."

Products affected: MapInfo Pro™
 

Issue

User has opened 2 very large tables that are being joined using a SQL query.
When the user tries to save the resultant query, an error is displayed:

"Error writing File size exceeds maximum of 2097152K.. object not inserted. "
User-added image


 

Cause

This error indicates the resultant query would exceed the 2 gig limit for classic MapInfo tab files.

Resolution

UPDATED: November 2, 2017
To resolve this issue in MapInfo Pro 15.2, 64-bit or later, when saving the query, click on the
"save as type" and choose "MapInfo Extended" to create a table in the new "Native X" or MapInfo Extended" format.
This new format does not have the 2 gig file size limit of the classic tab format.

User-added image
Please see the User Guide for MapInfo Pro 15.2 64-bit or later for more information on the new MapInfo Extended format.