Re: Oracle --> MS Access Example

It certainly can be done using Oracle transparent gateway to ODBC. It even comes free with Oracle 8.1.6....

Tzachi

"Eddie W. Stroud" <estroud_at_bolthouse.com> wrote in message news:3b8d1790$0$13473_at_wodc7nh0.news.uu.net...
> I don't have an example without knowing a bit more about what you are
trying
> to accomplish but, even though you can't link directly, you may be able to
> accomplish what you want by writing some code both in ACCESS (VBA) and
> Oracle to pass data back and forth. You could probably give the illusion
of
> real-time to your users.
>
> For example, I've written text files out from ACCESS as a text file to a
> folder accessible to UNIX. The Unix box checked every 15 seconds to see if
> data was present to process. Access looked for data and updated its tables
> based on a user starting a form that used data. Pretty simple stuff but it
> worked well.
>
> Java stored procedures can communicate between Oracle and the outside
world
> and Access can too. It just takes a bit of research and work. Billy may be
> right in that it would be easier to just convert. I would like to think
that
> even GW would adjust his schedule for me if it was important enough.
>
> Ed
>
>
> Billy Verreynne <vslabs_at_onwe.co.za> wrote in message
> news:9m5d81$2vb$1_at_ctb-nnrp2.saix.net...
> > "Tarik" <tarik_sadat_at_amat.com> wrote in message
> > >
> > > Can anybody provide me with an example of how to get a database link
> > > going from an Oracle 8.1.6 database to MS Access (V7 or higher)?
> >
> > An example? Nope! Forget it!
> >
> > Not because I'm particularly crankier than usualy, or ran out of coffee,
> but it
> > is simply not possible. :-)
> >
> > > I only need read access to the Access database from Oracle, so I'm not
> > > interested in transactions etc.
> >
> > Transactions are not the issue.. the idea of using an Oracle client to
> connect
> > to an Oracle database system in order to read data from a MS Access
> filebase..
> > it is like telling the US president that he has to fit in with your
> schedule for
> > an appointment. :-)
> >
> > > I have studied the Heterogeneous Services part of the manual, but it's
> > > not very helpful.
> >
> > No, as this only provides distributed access to other Oracle databases,
or
> > Oracle gateways for other full blown database systems like Informix and
> > SQL-Server.
> >
> > Simply migrate the Access database to Oracle. It is the simplest
solution.
> > Oracle provides migration tools for getting an Access database into
> Oracle.
> >
> > --
> > Billy
> >
> >
> >
>
>
Received on Thu Aug 30 2001 - 04:39:09 CDT