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.