Connecting to Oracle with Access front end via VBA

#11

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

#12

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

#13

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Connecting to Oracle with Access front end via VBA

comp.databases.oracle.misc comp.databases.oracle.misc

Re: Connecting to Oracle with Access front end via VBA - 02-29-2008 , 08:22 PM

Re: Connecting to Oracle with Access front end via VBA - 02-29-2008 , 08:22 PM

Re: Connecting to Oracle with Access front end via VBA - 02-29-2008 , 08:22 PM