> I am using Access as a Front End (GUI) and want to connect
> Access to an Oracle Database. How do I do this? Also, How
> do I call a Oracle Stored Procedure.

> > I am using Access as a Front End (GUI) and want to connect
> > Access to an Oracle Database. How do I do this? Also, How
> > do I call a Oracle Stored Procedure.
> You need to use either the Microsoft or Oracle ODBC driver. Create a DSN
> to your database using the ODBC Manager in Windows Control Panel, then
> use that connection to link the tables into Access (File, Get External
> Data, Link Tables).

> Call stored procedures requires you to put the procedure within a
> BEGIN...END block inside a passthrough query.

> Hope this helps

> --

> Tony Oakley (Microsoft Access MVP)
> GSXR1300R Hayabusa
> 300hr 240GB TiVo