Re: synchronize MS Access and Oracle tables

you could always just convert the access database to an oracle database.

then set up an ODBC connection so that clients/customers still use access to update but they are updating tables which are infact on an oracle server.

that way you only have to maintain ONE database system.

of course if you still need the access database maintained then i'm stuck :-()

"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 - 19:25:19 CDT