I have created an Oracle table with a primary key and two alternate keys. When I link to it via odbc using Oracle in OraHome92 driver, I loose the PK and one of the AKs. Access or ODBC chooses one of the AKs as the PK and the original PK only has a non-unique index.
I ended changing the AKs to Inversion Entries, keeping the indexes, but loosing the uniqueness that I need. Any help would be much appreciated!