Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: synchronize MS Access and Oracle tables
try DFM www.peterssoftware.com/dfm.htm
"Jeff Y. Y." <yuanjeff_at_yahoo.com> wrote in message
news:a2bc9497.0204130907.5d88b2f6_at_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 - 22:51:49 CDT