Acc2 <-> Oracle 7.x: Primary key wanders...

From: Martin Schroeder <ms_at_dream.hb.north.de>
Date: 1996/08/31
Message-ID: <+VQKyAINBh108h_at_dream.hb.north.de>#1/1


Hi,
we are using Access 2.0 on Win 3.1x as a client for an Oracle 7.x database. We recently noticed that Access and Oracle have different opions about which index is the primary key for an Oracle table. The setup in Oracle is correct---say a table has two keys A and B, both are unique, and A is the primary key---but Access thinks that another index is the primary key---B in this example. This problem persists even with a fresh database and newly attached table.

Any ideas?

Thanks in advance

        Martin

P.S.: We are uncertain if the differing opinions of Access will have any

      influence on its operation...
P.P.S.: We _have_ the latest ODBC-driver from Oracle P.P.P.S.: Followup-To: comp.databases.ms-access !

-- 
               Martin Schr"oder, MS_at_Dream.HB.North.DE
Governments of the Industrial World, [...]
These increasingly hostile and colonial measures place us in the same
position as those previous lovers of freedom and self-determination
who had to reject the authorities of distant, uninformed powers. We
must declare our virtual selves immune to your sovereignty, even as we
continue to consent to your rule over our bodies. We will spread
ourselves across the Planet so that no one can arrest our thoughts.
	(John Perry Barlow: A Cyberspace Independence Declaration)
Received on Sat Aug 31 1996 - 00:00:00 CEST

Original text of this message