[AccessD] Pull Data From Oracle Into Access XP

Thanks Jim!  Your example code would be a great help.  

Is this an example of a pass-through query?

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Tuesday, January 18, 2005 9:06 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Pull Data From Oracle Into Access XP

Hi Dan:

It sure can. You have to use an ADO connection, send a SQL query through the
connection and retrieve and process the results through a recordset. It is
not difficult. If you need some code send all a request.

HTH
Jim 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: Tuesday, January 18, 2005 12:36 PM
To: Database Advisors
Subject: [AccessD] Pull Data From Oracle Into Access XP

I have an application where I need to routinely look up information in an
Oracle database.  Can this be done without pulling the entire contents of
the table (or tables) into Access each time?

 

Thanks,

Dan Waters

ProMation Systems        

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com