Re: Connecting to Oracle with Access front end via VBA

From: Galen Boyer <>
Date: 24 Feb 2008 11:10:01 -0600
Message-ID: <>

On Fri, 22 Feb 2008, 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
Received on Sun Feb 24 2008 - 11:10:01 CST

Original text of this message