Pass through query link oracle table to local access table

Pass through query link oracle table to local access table

Post by c2o » Thu, 28 Aug 2008 00:30:10


can some one help me to link oracle tables to local database table in this
pass through query?

Pass through query with orcale tables only:-

select
pch.claim_number,pm.provider_id,vm.vendor_id,mm.subscriber_id,pch.line_of_business
from doris.profsvc_claim_header pch,doris.prov_master pm,doris.member_master
mm,doris.vendor_master vm
Where pch.seq_prov_id = pm.seq_prov_id
and pch.seq_memb_id=mm.seq_memb_id
and pch.seq_vend_id=vm.seq_vend_id
and pch.date_received>='1-JAN-08'
and pch.line_of_business IN('WCM','LMR')


Local access table I want to link to the oracle tables.

PRT_CLAIMS_REPORTING.Claim_Number
 
 
 

Pass through query link oracle table to local access table

Post by Douglas J. » Thu, 28 Aug 2008 06:17:18


A pass-through query cannot communicate with local tables.

The only possibility is to create a second query that joins the pass-through
query to the local table(s).

--
Doug Steele, Microsoft Access MVP
http://www.yqcomputer.com/
(no private e-mails, please)

 
 
 

Pass through query link oracle table to local access table

Post by jaim » Sun, 19 Oct 2008 11:21:05

jaime is the hotest