Linking Orcale DB into Access

  • Thread starter Thread starter Magnus
  • Start date Start date
M

Magnus

Hi, really hope someone can help as I am going daft with
this!

I have a Oracle database (which I have no direct access
to) and am linking the tables into Access via Oracle ODBC
8.01.07.810

The database is a fully normalised, live system and it
absoloutly massive. There is one table called SCHEDULES
which is the largest of all the tables. When I try to
link it, it comes up with an error which says:

"Operation Failed. There are too many indexes on table
Schedules. Delete some of the indexes and try again."

Is there another way to link a table into access which
ignores the number of indexes, or disable the check? I am
sure there is a workaround as another branch of my company
has managed it, but it was so long ago that they cannot
recall how. I have tried with Access 97, 2000 and 2003
all to no avail.

Any help offered would be much appreciated, even if it is
to tell me that I should post this in an ODBC newsgroup,
or that is is 100% without a shadow of a doubt impossible
to ignore the index limit. :)

Cheers
Magnus
 
You 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 Statement" 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. See the "Send commands to an SQL
database using a pass-through query" help topic in Access for more
information.

Hope this helps.
 
Hi Brian,
Thanks for this. You were right I had no access to the
Oracle Backend, but the passthrough query works perfect.
You may just have saved my sanity! :)

Cheers
Magnus
 
Back
Top