Re: problem from oracle to access (odbc)

From: Steve M <steve.mcdaniels_at_vuinteractive.com>
Date: Fri, 4 Oct 2002 11:30:14 -0700
Message-ID: <ankmlg$4ms$1@spiney.sierra.com>

MS-Access needs to think there is a primary key field in the table.

When you establish the link to the table, MS-Access will try to automatically
determine which field is the primary key field. If MS-Access can't determine which
field, it will show you all fields and let you pick on (or more).

If there is no primary key field on the table, you can still insert (via Access) if you
tell Access that one or more of the fields is the key field (even though they aren't).

"--- YURYSSG ---" <yuryssg_at_yahoo.it> wrote in message news:anjkj6$emhfr$1_at_ID-158528.news.dfncis.de...
>
> I have set up an Oracle link to Access by ODBC (user = DBA)
>
> All OK, under Access I see the Oracle tables ... but I am not able to
> modify/write on them!
>
> What do I mistake?
>
>
>
>
Received on Fri Oct 04 2002 - 13:30:14 CDT