Re: Connecting to Oracle with Access front end via VBA
Date: Fri, 29 Feb 2008 18:22:26 -0800 (PST)
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