General discussion
Thread display: Collapse - |
All Comments
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Connecting a Oracle Database to a MS Access database
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.