Linking to Oracle: Too Many Indexes Error Received

[Craig Nestel]

I'm getting a "Too Many Indexes" error when attempting to
link to an Oracle database. Are there any workarounds?

 

[Brian Camire]

Your might try one of the following:

1. Create a view in Oracle of the table and then in Access link to the view
instead of the table. Note that, by default, the linked view will not be
updatable. If you need it to be updatable, you can define a "pseudo index"
*in Access* to identify which the field(s) whose values uniquely identify
each record. See the CREATE INDEX help topic in Access for more
information.

2. If for some reason you are not able to create a view in Oracle, but you
can live with the table being not updatable, you might try creating a
pass-through query in Access instead of linking to your table (or view).
Pass-through queries are not updatable.

Hope this helps.

 

[Craig Nestel]

Thanks for the response. Yes, this is very helpful as I
don't need to update the Oracle table. I simply need to
access the Oracle table in read-only mode so that I can do
some reporting/analysis of the tables. I'll give this a
try.