Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: synchronize MS Access and Oracle tables
On 13 Apr 2002 10:07:04 -0700, yuanjeff_at_yahoo.com (Jeff Y. Y.) wrote:
>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
Without knowing more about the apps, you could define the tables in Access to be
ODBC linked to oracle. Then the tables that Access is addressing are actually
the oracle tables. No need to come up with a scheme to try to replicate the
data.
Received on Mon Apr 15 2002 - 08:11:57 CDT