[QODBC-Desktop] Too Many Indexes Error
Posted by brad waddell on 12 March 2009 05:21 PM
Troubleshooting: Too Many Indexes Error
Problem Description 1
I just purchased QODBC Desktop Driver for QuickBooks USA 2008 Read Only. I am running QuickBooks 2006 - the 5-user version where the QB file is on a server. I installed QODBC and can connect to most of the tables just fine via ODBC and MS Access 2003. Some tables give me an error when linking to them in Access. For example, the table InvoiceLine gives me the error: "The Operation Failed. There are too many indexes in the table 'tmp%#MAU@.' Delete some of the indexes on the table and try the operation again."
This is a confirmed bug using QODBC v8.00.00.234 and MS Access 2003 or 2007. We are investigating the issue and will advise a workaround or a fix shortly here. When using QuickBooks 2007, these tables have too many optimized indexes:
Note: This issue has been fixed now. Please try to download our latest version of QODBC.