I agree that it is possibly the worst idea I have seen in a while. However
Oracle9i ships with a feature called 'Generic Connectivity' (not sure if it
is there in 8i) which allows connection to any OLEDB or ODBC data source
(presumably though I've not looked through the extproc interface). This
would appear to allow what the OP wants.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"damorgan" <damorgan_at_exesolutions.com> wrote in message
news:3C8CD41D.CC708FAE_at_exesolutions.com...
> I do not believe it can be done. Nor can I imagine why anyone would want
to.
> Put the data into Oracle and drop Access. It offers nothing that can not
be
> done better and faster and safe in Oracle.
>
> Daniel Morgan
>
>
>
> Rastko wrote:
>
> > How should I configure Oracle Client to access the MS Access tables
using
> > ODBC?
> >
> > I've found instructions for accessing Oracle tables from MS Access,
> > but I need to create an Oracle database link to mdb file.
> >
> > thanks,
> >
> > Rastko
>
Received on Mon Mar 11 2002 - 10:49:59 CST
