I have a VB6 front end application that updates,adds and deletes records in an Access 2003 DB. I also have set up an Oracle DB that I want to be an exact duplicate of the Access tables. Is there any way when inserting, updating, or deleting records in Access to have Access automatically make the same changes in Oracle? Maybe thru an ODBC link or trigger or something?
As another solution, Is there some way to just replicate Access 2003 tables to Oracle or sync them up, say once or twice a day?