Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: update oracle database when ever changes are made in access database

Re: update oracle database when ever changes are made in access database

From: Varun <varuns123_at_ggn.hcltech.com>
Date: 29 Jul 2004 04:22:58 -0700
Message-ID: <a76d8c39.0407290322.b9b36bc@posting.google.com>


thanx for the suggestion burt but will the oracle table get updated everytime the when ever access tables are changed. i think i have to just manually update the tables in the linked tables how to update the new data each time automatically. just like using triggers in the oracle. what should i do here to make it fast and automatic "Burt Peltier" <burttemp1REMOVETHIS_at_bellsouth.net> wrote in message news:<Lt_Nc.54827$Yw3.12831_at_bignews3.bellsouth.net>...
> You probably have some good reasons, but why didn't you just "link" the
> Oracle table into MS Access?
>
> We do this a lot and it works good.
>
> Just make sure the Oracle table has a unique index or you specify a unique
> set of columns to identify 1 row when you link the table into MS Access.
>
> --
>
> "Varun" <varuns123_at_ggn.hcltech.com> wrote in message
> news:a76d8c39.0407272029.5df9d058_at_posting.google.com...
> > Hi all,
> > well i have migrated the database from access to oracle and changes
> > would be done in access only so i want to make same changes in the
> > oracle database say after 10 mins. or so everytime i.e a continuous
> > process either changes made or not so what should i do.
Received on Thu Jul 29 2004 - 06:22:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US