Linking Access and Oracle Database

[Anka]

Hi, everyone.

I need to enable communication between 2 databases, one is Access and
the other is Oracle database. Further, I need to update one table in
Access with the values from Oracle table.

I exported table wich I tend to update from Access to Oracle and made
a link to that table, so I can see changes made in Oracle in Access
via that link. But, I can't manage to update table in Access using
that link and that is what I need to do.

Please, How can I update Access table with a values that are already
stored in Oracle table - I made a link on that Oracle table from
Access?

Can someone please help me with this?

Thanks a lot!
Ana

 

[David W. Fenton]

:

I need to enable communication between 2 databases, one is Access
and the other is Oracle database. Further, I need to update one
table in Access with the values from Oracle table.

I exported table wich I tend to update from Access to Oracle and
made a link to that table, so I can see changes made in Oracle in
Access via that link. But, I can't manage to update table in
Access using that link and that is what I need to do.

What have you tried that didn't work?

 

[Pat Hartman]

Jet requires that all fields be updateable in an update query or it makes the query non-updateable. Joining a Jet table to an Oracle table does not inherently make a non-updateable query so you need to do some investigation to determine what is causing the problem. One possibility is that there is no primary key defined for the Oracle table.

The source of the problem would dictate the solution but in all cases, importing the Oracle table and adding a primary key if necessary will allow you to join to the local table to do the update and that will solve the problem.

We'd need more information to come up with the best solution.