Re: Connecting to Oracle with Access front end via VBA
Date: 24 Feb 2008 11:10:01 -0600
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 BoyerReceived on Sun Feb 24 2008 - 11:10:01 CST