Li nking to a tables with more than 32 indexes

A

Amy McFall

I am trying to run a report from a ORACLE DB using access. One of the tables
I need to use has more than the allowed 32 indexes, so I can not link or
import it. Is there anyway to get around this?
 
R

Rick Brandt

Amy said:
I am trying to run a report from a ORACLE DB using access. One of
the tables I need to use has more than the allowed 32 indexes, so I
can not link or import it. Is there anyway to get around this?
Click to expand...

If you are able you can construct a View on the Oracle server and link to
that instead. Access might not consider the indexes on the source table to
be applicable to the View and will not raise the error. I have had to do
this a few times against an IBM UDB database and it has always worked in
that situation.
 
Top