Re: Acc2 <-> Oracle 7.x: Primary key wanders...
From: Martin Schroeder <ms_at_dream.hb.north.de>
Date: 1996/09/02
Message-ID: <hQ5KyAjOBh108h_at_dream.hb.north.de>#1/1
Date: 1996/09/02
Message-ID: <hQ5KyAjOBh108h_at_dream.hb.north.de>#1/1
In <01bb98da$e3a5b180$b6db23c7_at_BISHOP_95.DASD-INC> "Edwin Cholewa Jr." <echolewa_at_ix.netcom.com> writes:
>> 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.
>First of all Is Key A defined as a primary key or a unique field?
>Second, in you table's profile (On Oracle) which index is listed first?
A is primary and the first index.
Regards
Martin
-- Martin Schr"oder, MS_at_Dream.HB.North.DE Oh, the comfort, the inexpressible comfort of feeling safe with a person; having neither to weigh thoughts nor measure words, but to pour them all out, just as they are, chaff and grain together, knowing that a faithful hand will take and sift them, keep what is worth keeping, and then, with the breath of kindness, blow the rest away. (Dinah Mulock [not sure])Received on Mon Sep 02 1996 - 00:00:00 CEST