Pass Through Query using Local Access Table

K

Kirk P.

I'm hoping to create a pass through query to retrieve records from a large
(6.4 million record) Oracle database. I want to limit the records chosen
using a local access table. I've written the SQL, but so far no luck.
Either my SQL is wrong, or it isn't possible to join a local access table to
an Oracle table through a pass-through query.

Any ideas?
 
O

Ofer

The pass through is a type of view, it sits in the mdb but work on your
server, so it will recognise only tables that sit on the server.
but you can create another select query that combain the pass through query
and the linke table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pass Through Query - not returning rows 1
Pass-Through Query Error 1
Access pass-through query to Oracle 10g stored procedure - results 1
Pass-Through query used to update an access table 2
Pass Through Query Make Table 3
Question on Pass-through Query 4
Is It Possible To Pass Parameters to A Pass Through Query 2
Using pass-through query results in forms 0

Top