Linking a Table within MS Access fails with "There are too many indexes on table 'tablename'.".

« Go Back


EnvironmentProgress 9.1x
Question/Problem Description
Linking a Table within MS Access.
The operation failed.
There are too many indexes on table 'tablename'.
Delete some of the indexes on the table and try the operation again.
A table involved in the query has many (greater than 20) indexes.
Could not remove any indexes on the table due to third party application.
Clarifying Information
Error Message
Defect/Enhancement Number20030507-003
This is known issue.

You're hitting the SQL engine field components index limit.
For each table, there can only be up to 250 index components. Therefore if you have (say) 50 indexes, each with 6 index components, the table uses a total of 50*6=300 index components, which is higher than the limit.

Choose to Import the affected table into MS Access rather then Link.

- OR -

Upgrade the database to Progress 9.1D09 or later.

Was this article helpful?


Your feedback is appreciated.

Please tell us how we can make this article more useful.

Characters Remaining: 255


Copyright © 1993-2014. Progress Software Corporation. All Rights Reserved. See the next generation of application development and data connectivity software, try now!