Re: Connecting to Oracle with Access front end via VBA

On Fri, 22 Feb 2008, rlntemp-gng_at_yahoo.com wrote:
>
> There are some Oracle tables from a production database that my app
> will link to after some enhancements are made. The enhancement
> consist of needing to link to two Oracles tables to run a make-table
> quiery (which will create another local Access table)
>
> I have heard that to connect to an Oracle table totally via VBA code,
> that it is indeed not possible, because the end user's workstation
> must have 3 things:
> 1) the Oracle client installed
> 2) must have a TNSNAMES.ORA file with a reference to the backend db.
> 3) an ODBC data source must be set up separately on the workstation.
>
> Is this true? Can Oracle tables be linked to an Access DB (with none
> of the three above present)

One can link to Oracle without any of the above, but VBA is the one causing your percieved limitation and needs them.

-- 
Galen Boyer