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
|
|
Access 2007 linked tables |
Author |
Message |
|
Posted : 2007-10-03 07:03:17 |
When I try to link tables to an Access 2007 database, some of them give me the error "The operation failed. There are too many indexes on table '<name of table>'. Delete some of the indexes on the table and try the operation again." A few of the tables that did this are Sales, SalesLine, SalesOrderLinkedTxn and InvoiceLine. How do I fix this? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-10-03 07:30:42 |
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
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-10-13 11:41:14 |
|
|
|
|