This recordset is not updateable

[mkey]

Hi all,

I have linked a table that is in Oracle 8.1.7 through access 2000. I realized its not an access forum, but I think someone might have experiance this problem one time or another.

Well the problem is I linked the table though the access gateway. When I try to update the id column to change a value I'm getting the 'This recordset is not updateable' messauge.
The table structure is very simple:

create table table_A (id number(16) not null)
Values :1,2,3

Can someone found similar problem? If so how can I fix it.

Thanks

 

[miniboat]

Are you sure the error is from ORACLE?
I used to get same error from Access DB, the file property setup can cause the problem,such us read/only, or no full control privilege etc.
hope it is helpful.

 

[THoey]

Does the login that you used to connect to the Oracle DB allow UPDATE's, or just SELECT's? Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...

 

[comgrit]

i guess you link the Oracle table through ODBC, if that's the case, when you link the table, Access will ask you to select some of the field to be use as primary key on Access. You have to choose the unique combination of the key so that when ODBC send update request to Oracle, it will know which row to update.

Please also make sure that you define the primary key in Oracle table