Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle --> MS Access Example
"Tarik" <tarik_sadat_at_amat.com> wrote in message
>
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.
-- BillyReceived on Fri Aug 24 2001 - 06:12:26 CDT