(This is a note from Kim Nystrom)

HOW TO CREATE PASS-THRU QUERY IN ACCESS
-1- from query design view select:
         Query > SQL Specific > Pass-Thru
-2- from query design view select:
         View > Properties
         -3- hit the ellipse after the "ODBC Connection String" field and
select the EDW -
Production ODBC connection you hopefully already have.

At this point, you're set to go and can paste in a query and run it.  Note
that
electing to save password/connection settings can leave your password in
the
properties of the query in full glory.

If you have the EDW server as a linked server in MS SQL, you can run
passthrough
queries as well.  See the October post "How to: Add Oracle Linked Server
to SQL
Server"