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

From: <>
Date: Thu, 22 Nov 2012 04:14:23 -0800 (PST)
Message-ID: <>


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 Received on Thu Nov 22 2012 - 13:14:23 CET

Original text of this message