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

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

book

Article ID: KB0081890

calendar_today

Updated On:

Products Versions
Spotfire Analyst All supported versions

Description

When using Spotfire to connect to an MS-Access Database via ODBC, Spotfire may throw 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.
 

Issue/Introduction

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

Resolution

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.

 

Additional Information

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

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

Powered by Wolken Software