Skip to main content

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

Rich Talbot
  • Created
Date Posted:
Product: TIBCO Spotfire®

Problem:

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


Solution:

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.
  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

Comments

0 comments

Article is closed for comments.