Peachtree Quantum 2010 and Access 2000 ODBC error on linking LineItem table
Posted on 2011-05-03
I am using Access 2000 to link to Peachtree Quantum 2010 GL tables. I can link to every table BUT the LineItem (detail transactions) table. I get the error "too many indexes".
I find similar questions posed on different forums, but no solution. One comment I noticed was that it was the publisher of the pervasive database and not Peachtree that created the problem. Another said that Access can only handle 32 indexes versus the 33 on the LineItem table.
Anybody have a similar problem and a solution?