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

From: Mladen Gogala <>
Date: Sun, 25 Nov 2012 04:17:37 +0000 (UTC)
Message-ID: <>

On Thu, 22 Nov 2012 04:14:23 -0800, rutgeaw wrote:

> 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.

Mladen Gogala
The Oracle Whisperer
Received on Sun Nov 25 2012 - 05:17:37 CET

Original text of this message