Re: Oracle View / MS Access: 'Recordset not updateable'

From: Stephen Cox <Stephen_at_Glazier.co.nz>
Date: Fri, 19 Jun 1998 10:58:47 +1200
Message-ID: <6mc622$jbq$1@news.iconz.co.nz>

A view does not have any Primary Key or Unique Index info. Access uses the unique constraint information from ODBC to recognize row updates. Subsequently Access will not allow updates, as it believes it cannot uniquely identify the rows in the view...

Stephen Cox

Dan Hopkins wrote in message <6ljau9$32g$1_at_morse.news.easynet.net>...
>
>pkilmer_at_hersheys.com wrote in message <357c3951.28065869_at_news>...
>>I've defined a simple Oracle 7.2.3 table which I can update through
>>both SQL Plus 8.0.4.0.0 and via ODBC (Ora8 driver) in MS Access 7.0.
>>I've also defined a simple (I think!) view of the table which is also
>>updateable via SQL Plus, but yields the message 'Recordset not
>>updateable' when attempting to update the MSA 'table'.
>
Received on Thu Jun 18 1998 - 17:58:47 CDT