Re: Oracle and Access

From: bcoan <astrobran_at_yahoo.com>
Date: Thu, 26 Apr 2001 14:31:43 -0500
Message-ID: <VG_F6.2125$w7.620616@e3500-chi1.usenetserver.com>

I've done this many times and it worked like a charm!

"Stefan Landgraf" <stefan_at_living-source.com> wrote in message news:9bmob0$2226$1_at_wrath.news.nacamar.de...
> > I once heard I could use MS Access as a front end for Oralce.
>
> Access allows linking of tables from any ODBC compliant database.
> So all you need to do is
> - install the Oracle ODBC driver
> - create a DSN to the Oracle database
> - right click the database window in the tables tab
> - select 'Link Tables' from context menu
> - Choose ODBC databases as file type
> - select the Oracle DSN
> - Select the tables you want to access.
>
> I personally have no experience in how good this works
> with Oracle, with MySQL it worked fine.
>
> Hope that helps
> Stefan Landgraf
>
>
Received on Thu Apr 26 2001 - 14:31:43 CDT