Re: access/odbc writing to oracle-view

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Tue, 05 Nov 2002 18:51:15 +0100
Message-ID: <961gsugqjoar38me12cl8il9u496ic02pe@4ax.com>

On Tue, 05 Nov 2002 11:36:56 +0100, Hartmut Berghoff <h.berghoff_at_gmx.de> wrote:

>hello all,
>
>I am no experienced user of oracle. My problem is
>
>created a view with sqlplus named q_tab1_tab2
>holding all fields of the 2 tables with a common unique key in tab2 pointing
>to a key-field in tab1 (resulting in a join of the two tables)
>
>This view is not readonly according to dba-studio
>
>When I link an access-table to that view via odbc, I cannot write to any
>fields of that view.
>
>What can I do to have it writeable in access, or is it an
>abdc/access-problem to be covered by some other forum?
>
>Hartmut

You can't do anything as it is a 'feature' of Access/ODBC. Every updatable resultset needs *one* primary key. Obviously your view doesn't meet this requirement.

Sorry

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Nov 05 2002 - 11:51:15 CST