Hi Guys,
Has anyone tried linking an Oracle Database to Access and had an error about linking the table as it has too many indexes. This is a problem I have at the moment. I know for a fact the table has 32 (which is Access's limit) and before any one asks why, I didnt design the system, but it is fully normalised and absoloutly huge.

I have the Oracle ODBC drivers 8.01.07.810, and all tables link ok apart from this one. I have the same problem in both Access 97 and 2000. Odly the training database which is an exact duplicate of the Live one links this table ok, which leads me to believe that it isnt to do with the number of indexes but something to do with amount of data or widths? I also know that it is possible to workaround as another branch of my company had the same problem with the same system but got around it around 5 years ago but cant remember how. Is it possible to get access to ignore the number of indexes when linking?

Cheers
Magnus

What is the exact problem you are having. Are you selecting one field as the index when you link the table?



Sal

Pretty much what I said last time. I need to access data from a very large Oracle Database using Access, One of the main tables is called Schedules but when I try to create a link to this table Access says:

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

I cant delete any indexes, as I have no access to the Oracle Database and it is a live system. What I need to do is find a workaround so that Access either ignores the number of indexes or doesnt link them.

Magnus