Pass Through Query using Local Access Table

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?
.

Relevant Pages

  • [SLE] Open Office Database Wizard Question
    ... I'm trying to run an OpenOffice database query against an Oracle database on ... Syntax error in SQL Expression ...
    (SuSE)
  • Re: Oracle SQL vs. Access SQL
    ... > back end Oracle database. ... > and I'm hoping performance will improve using a pass through query as ... > translate complex Access SQL into Oracle SQL. ...
    (microsoft.public.access.queries)
  • SQL Help Please
    ... I have created a pass through query to get some data from a Oracle Database. ... The SQL in that query appears below. ... I am stuck on ...
    (microsoft.public.access.reports)
  • Re: Oracle JDBC Driver ps.setTimestamp() slows down query execution many times
    ... I perform simple sql query to Oracle database, ... provide them as strings (as you do in your hardcoded SQL example)? ...
    (comp.lang.java.databases)
  • RE: Pass Through Query using Local Access Table
    ... 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 ... I've written the SQL, ... > Either my SQL is wrong, or it isn't possible to join a local access table to ...
    (microsoft.public.access.queries)