General discussion
November 11, 2004 at 04:36 AM
phil hood

Connecting a Oracle Database to a MS Access database

by phil hood . Updated 21 years, 9 months ago

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 discussion is locked

All Comments