Pass Through Query using Local Access Table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kirk P. - 18 May 2005 21:02 GMT

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?

Reply to this Message

Ofer - 18 May 2005 22:06 GMT

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.

> 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
[quoted text clipped - 3 lines]
>
> Any ideas?

Reply to this Message