Kbase P3620: Error occurs when trying to import a table with 32+ indexes into Microsoft Access
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/31/2009 |
|
Status: Verified
SYMPTOM(s):
Exporting a Progress table into a MS Access database via SQL-92 ODBC driver
Linking a Progress table into a MS Access database via SQL-92 ODBC driver
Operations fails with error message
The operation failed. There are too many indexes on table '<tableName>'. Delete some of the indexes on the table and try the operation again.
FACT(s) (Environment):
Progress table has more than 32 indexes
No other error messages are displayed
No problem from other ODBC tool such as MS Query or WinSQL
Progress 9.1x
OpenEdge 10.x
Windows
MS Access 97
MS Access 2003
CAUSE:
The table in the Progress database has more than 32 indexes defined. Microsoft Access is limited to 32 indexes per table.
FIX:
1. Make a copy of the Progress database.
2. Remove so many indexes from that copy in the Progress table that it's number is below the limit
3. Then export that table of the copy of that Progress database into Microsoft Access