Re: Oracle to Access Migration/Conversion

Hari Om wrote:

> Thank You Daniel Morgan.
>
> I know it is quite weird for Convertign Oracle to Access. The reason I
> am converting is bcos th epeople using the application are NOT
> familiar/used to Oracle DB. They are experts in Access. So, we thought
> WEB Application would interact with Oracle and would have a way for
> users to EXPORT to Access and download the DB and use Access for
> Analysis purposes.
>
> My Oracle DB is very small.
>
> Any related information on above is appreciated.
>
> THANKS!
>
> DA Morgan <damorgan_at_exxesolutions.com> wrote in message news:<3E89DE96.25AC59CF_at_exxesolutions.com>...
> > Hari Om wrote:
> >
> > > Hello Everyone,
> > >
> > > Greetings!
> > >
> > > I am using Oracle 9.2 DB and have a Web Application written in
> > > Servlets/JSP.
> > >
> > > Everyday _at_ 6:00pm I want to convert my Oracle DB to Access DB - what
> > > is the Best way to do this...? is it possible? what tools would I need
> > > to achieve this? ANy related information on this is appreciated.
> > >
> > > THANKS!
> >
> > Possible yes if it is small. But about as ridiculous a thing to do as I
> > can possibly imagine.
> >
> > Please explain why you would want to violate security and move from a
> > robust database to an electronic version of 3x5 cards?
> >
> > There is nothing you can do in Access you can't do leaving the data
> > exactly where it is.
> >
> > Daniel Morgan

Connect Access forms to the Oracle database using ODBC, ADO, whatever ... but don't move the data.

Large or small it is just introducing danger and work with no redeeming value.

Daniel Morgan Received on Wed Apr 02 2003 - 01:42:22 CEST