Re: Connecting to Oracle with Access front end via VBA

From: RLN <rlntemp-gng_at_yahoo.com>
Date: Fri, 29 Feb 2008 18:22:26 -0800 (PST)
Message-ID: <cddc920d-8edf-4827-b20b-419677b13fe1@m36g2000hse.googlegroups.com>


After trying different things, I did manage to use VBA exclusively to:
-Link to Oracle
-Use SQL to retrieve data (then I loaded that data into an ADO
recordset and closed the Oracle connection) ...and no ODBC connection was needed.
I did have to have the Oracle Client and TNSNAMES.ORA file, both of which are loaded on the user's PC.

RLN Received on Fri Feb 29 2008 - 20:22:26 CST

Original text of this message