Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: update oracle database when ever changes are made in access database
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