synchronize MS Access and Oracle tables

From: Jeff Y. Y. <yuanjeff_at_yahoo.com>
Date: 13 Apr 2002 10:07:04 -0700
Message-ID: <a2bc9497.0204130907.5d88b2f6@posting.google.com>

Hi,

We have two applications by two vendors: one in Oracle 8.1.7 and one in MS Access. We have to make them talk with each other. The goals are once data are inserted into Oracle, some of them will be sent to Access for updating Access tables. On the other hand, once data are inserted into Access, some of them will be inserted into Oracle. The two directions should be automatic, or in real-time synchronization.

One of the solutions may be create a link between MS Access and Oracle, and then do some "mapping". My questions will be

1. Can the database link do the both directions?
2. How can I create the links? 
3. What should I install to so that? It will be great if you could

ponit me to some documents.

Thanks a lot.

Jeff Received on Sat Apr 13 2002 - 12:07:04 CDT