Re: Oracle --> MS Access Example

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 Wed Aug 29 2001 - 11:25:48 CDT