Re: ODBC and Access Question?

How do you get SQL pass through under Access? I've used it in VB3 but not in Access. Since the passthrough option sends the entire string to the ODBC server (in this case Oracle) for processing, I don't see how it would work.

options:
1) Copy the fields of the required records across to the server (or back to your own machine), thus implementing it as a single table instead of a UNION, then delete the excess records when you're done. 2) forget about the passthrough option (after you've told me how to do it) and let JET (Access) do all the SQL stuff - have a look at the HELP files under DATABASE(SQL).
3) If you can set the PASSTHROUGH option for one query, use it in one query, create another which accesses your local data and a third which is a UNION of the previous two.

Guy Mofley <mofleyga_at_bp.com> wrote in article <01bc37be$4453fc80$567e63a1_at_nsupbuw16683.anc.xwh.bp.com>...
> I'm trying to build a sql pass through query that appends data from a
 local
> table in my access database to one on our server which is running oracle
> 7.3. I'm using the insert into command syntax. I'm not sure how to
> address the local tables in the sql commands. Can this be done? It may
 be
> that the nature of a pass through prohibits such a request, but I don't
> know.
>
> Guy
>
Received on Tue Mar 25 1997 - 00:00:00 CET