We're about a month out from our Feb '10 upgrade cutover, and our Reporting gurus here are testing out some existing MS Access connectivity that we have via ODBC, but against the Feb '10 upgrade site, to work out any compatibility/schema kinks prior to the upgrade.
Our Reporting guru, upon trying to link to the tables on our Upgrade site from Access, got an error on several tables that:
"The operation failed. There are too many indexes on table '<table_name>'. Delete some of the indexes on the table and try the operation again."
Most of the tables came down, but a respectable handful (including 'incidents') threw the above error when Access tried to link to the table.
We have several business-critical reports that are generated via Access & ODBC, so this is obviously a huge concern for us; hoping someone had seen this before & knew a fix, or had some insight on where to start troubleshooting. Obviously I doubt Hosting & the DBAs would be too keen on remove indexes from the table. :)
Using MS Access 2003 (SP3) and the 5.1.6 MySQL ODBC/Connector driver for the connection.