ORACLE PROBLEM - Linked Tabled-Update Query

[veddas2002]

Hello Everyone,

Here is my issue:

1. I have linked a table which does not allow me to update any entries.
2. In this linked table I have to update one column that contains all null values
3. I have another table that contains the values required for that one column in the linked table

When I try running an update query after doing an Inner Join, i get the Operation must use an updateable query error...is there ANY work around at all ? Please let me know . any help would be greatly appreciated.

 

[boblarson]

1. I have linked a table which does not allow me to update any entries..

What is this linked to? Is it to another Access database, SQL Server, what?

 

[veddas2002]

its a linked ODBC table...btw pardon me i am not an expert...is that good enuff info?

 

[boblarson]

ODBC to SQL Server? If so, you have to make sure that the SQL Server table you are linked to has a primary key. Also, when you link your table it may ask you to identify the primary key field and if you don't then it will be read-only and not able to be updated.

 

[veddas2002]

hmmmmm....i just link it to a oracle database....and when i link it does not ask for a primary key....

 

[boblarson]

I don't have Oracle experience, so I may not be much help. But, does it HAVE a primary key field in the Oracle DB itself?

 

[veddas2002]

yes it does but when i link it, it doesnt seem to show ...hmmmmm..thanks for your help btwww....what hsould i do now?