Knowledgebase
[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."

Solutions 1

     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:

CreditMemoLine
CreditMemoLinkedTxn
EstimateLine
InvoiceLine
InvoiceLinkedTxn
PurchaseOrderLine
Sales
SalesLine
SalesOrderLine
SalesOrderLinkedTxn
SalesReceiptLine

Note: This issue has been fixed now. Please try to download our latest version of QODBC.

(233 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).