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