Linking table in Access from Pervasive SQL

[gpeters]

I'm trying to link a table from a Pervasive SQL database with 35 indexes and get this error in access.

The operation failed. There are too many indexes on table 'CUSTOMERS'. Delete some of the indexes on the table and try the operation again. (Error 3626)

The table is from a ERP system and I can't delete the indexes. If I delete the indexes I get an error in the ERP system. Is there any way around this?

 

[HiTechCoach]

As far as I know, Access can only handle 32 indexes per table.

 

[SimonB1978]

Hi,

Do you need the data in real-time? If not, you could create yourself a copy of this table (minus the indexes) and update it as needed with the "master" table.

Or maybe you can create a view and link to that?

Simon B.

 

[gpeters]

I've now created a view from the Customer table with all the fields in it and it works.

Thank you Simon B...