General discussion


Connecting a Oracle Database to a MS Access database

By Phil Hood ·
We are currently investigating into the possibility of remotely connecting to a Microsoft Access [2000] database within Oracle 8.1.7 and 9i.

We currently have linked oracle tables in the Access database that are manual updated with new data, but are trying to automate the process directly within Oracle by (ODBC)

We are also looking at a plan B, where we us a PL/SQL procedure/function to call a stored Java class inside the oracle database that fires of the update query in the Access database to update the data.

Unfortunately the team have had little luck finding any good Web site with any descriptions on how to achieve the databases ODBC link between Oracle and Access.

Could any one please point the team to any good Web site or pass your comments on regarding plan B.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

This may help.

by adam_wetch In reply to Connecting a Oracle Datab ...

The best forum for you i would think would be this one. They are very familiar with ODBC/Access/Oracle (of course)/PL/SQL etc..

I would try and answer your question but i think the replies would be more accurate if posted there.

Collapse -

Oracle >Access

by nigel.forge In reply to Connecting a Oracle Datab ...

Related Discussions

Related Forums