Page 1 of 1

Oracle & Microsoft Access Table Synchronization

Posted: Mon Apr 09, 2007 3:07 am
by fahedakhter
I want to Synch Oracle & Ms Access Table data. When User Insert data in Oracle table the MsAccess table also synch with this record. And when I delete record from Oracle table then it also delete from MsAccess table how can I do this. I use Oracle Hetrogenious Service but it does'nt work on Linux As4. I use Oracle 9i on Linux As4. Would Linux support Microsft Access or not.

Reagrd's
Fahed

Posted: Mon Apr 09, 2007 4:02 am
by admin
Dear you need to have Linux ODBC for MS Access and after creating connection write triggers on oracle table. thanks

http://www.easysoft.com/products/data_access/index.html