Error When linking Oracle Tables to Access
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?