Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
Too Many Indexes Error |
Author |
Message |
|
Posted : 2007-10-04 00:59:42 |
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 I can connect to most of the tables just fine via ODBC and MS Access 2003. There are some tables that give me an error when trying to link to them in Access. For example, the table InvoiceLine gives me the error: "The Operation Failed. There are too many indexes on the table 'tmp%#MAU@'. Delete some of the indexes on the table and try the operation again."
What should I do? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-10-04 07:00:09 |
This is a confirmed bug using QODBC v8.00.00.234 and MS Access 2003 or 2007. We are currently investigating the issue and we will advise either a workaround or 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 |
|
|
|
|
Posted : 2007-10-12 03:36:17 |
When is this going to be fixed? It's causing a lot of delays for me.
--Scott |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-10-12 09:45:43 |
It is being worked on right now. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-10-13 11:38:26 |
|
|
|
|