Spotfire Client: Connecting to MS Access database via ODBC may result in 'Too many fields defined' error

When using Spotfire to connect to an MS-Access Database via ODBC you can see the following error:

OdbcException at ACEODBC.DLL:
ERROR [HY001] [Microsoft][ODBC Microsoft Access Driver] Too many fields defined. (HRESULT: 80131937)

The error "Too Many Fields Defined " is a known issue with MS Access (refer to the links in the "Reference" section of this article) and is caused by an issue with the internal column count within the Access database tables.

  As per the Microsoft KB articles, follow one of the resolution methods below to free the internal column count:

• Compact the database. On the Tools menu, point to Database Utilities, and then click Compact and Repair Database.

-or-

• Create a new copy of the table. To do so, follow these steps:
• Make note of any relationships with the table.
• Select the table.
• On the File menu, click Save As.
• In the Save Table 'table name' To box, type a new name. Click OK.
• Select the same table that you selected in step 2, and then press DELETE.
• Rename the table that you saved in step 3 to the original table name.
• Re-establish any relationships with the new table.

https://support.microsoft.com/en-us/kb/198504

https://support.microsoft.com/en-us/kb/291556