Re: Linking an Oracle table to MS Access via ODBC: Access assigns wrong primary key to linked table

> Hello,
>
> I'm using Access to link to tables of a calculation tool that's been
> built on a Oracle back end.
> I recently updated that tool, and now it seems something has been
> changed in Oracle that causes Access to automatically assign the wrong
> primary keys to certain tables. This happens when I update the tables
> using the connectivity wizard or when re-linking the tables.
>
> Is there a way to prevent Acces to automatically put keys to the Oracle
> tables I'm trying to link using ODBC? If I'm linking MySQL tables the
> ODBC connection wizard of Access always asks which column(s) to assign
> as primary key.
>
> Please advise and many thanks in advance,
> Wijnand

Given the amount of information you gave me to work with, I believe that you need to shine the Braille toad.
(http://www.dilbert.com/2012-11-23/)

-- 
Mladen Gogala
The Oracle Whisperer
http://mgogala.byethost5.com