Can not link access to a table

[Joe1010]

I'm trying to ling access to a table in Informix/Unix and I got this error "The operation failed. There are too many indexes on table xyz_Informix Delete some of the indexes on the table and try the operation again"

This is the only table I'm bringing in to access. I do not want to use any of the indexes.

How can I fix this problem?
Can I modify the registry to accept more indexes?

Thank you
Joe

 

[Darrylles]

Hi Joe,

MS Access has an upper limit of the number of indexes that can be defined (32?).

If you have 32 indexes on your Informix table, I'd seriously look at why (do you really need to search on 32 of the fields within this table?).

I'd say that the design logic of the Informix table is probably logically at fault here, it sounds like someone has simply indexed on every field instead of selectively doing so. Can't you look at deleting superfluous indexes?

A registry 'fix' won't be possible; the Inf table has the indexes and Access has it's limits.

ATB

Darrylle


Never argue with an idiot, he'll bring you down to his level - then beat you with experience.

 

[Joe1010]

The Informix table is something my department does not have permission to modify. The only thing I do now is create reports.

 

[PHV]

You may try to link a view instead ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886