Too Many Indexes

[jeffbert]

I am trying to connect to an ODBC table, which I have connected to many times
before. However, I am getting the error "The operation failed. There are too
many indexes on table "INVMST". Delete some of the indexes on the table and
try the operation again. If i try to link the table on other machines, it
works fine. I tried deleting other ad hoc databases that I had on my machine
that were no longer needed, and it still would not connect. there is only one
index set up in the table on the server. Nothing seems to work. Any ideas?

 

[John W. Vinson]

I am trying to connect to an ODBC table, which I have connected to many times
before. However, I am getting the error "The operation failed. There are too
many indexes on table "INVMST". Delete some of the indexes on the table and
try the operation again. If i try to link the table on other machines, it
works fine. I tried deleting other ad hoc databases that I had on my machine
that were no longer needed, and it still would not connect. there is only one
index set up in the table on the server. Nothing seems to work. Any ideas?

Have you tried:

- connecting from a new, empty .mdb frontend?
- deleting the connection from your database, Compacting, and connecting to it
anew?

John W. Vinson [MVP]

 

[dbahooker]

MDB IS CRAP; I sometimes see this error; finally I had enough with the
unpredictability so I moved to ADP a decade ago


Access Data Projects; you can just use an automated tool to create the
optimal indexes for you


ADP all the way!