Connecting to Oracle with Access front end via VBA

From: RLN <>
Date: Fri, 22 Feb 2008 19:26:09 -0800 (PST)
Message-ID: <>

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) long enough for an extract, then disconnected? I have experienced many headaches with older apps with an Oracle back ends, because I learn the user's workstation was reimaged  and they therefore lost the 3 items I mentioned above. Reconfiguring ODBC connection services on the client is cumbersome.

If there is a simple solution via VBA that would be a life saver.


RLN Received on Fri Feb 22 2008 - 21:26:09 CST

Original text of this message