How to Create Pass-thru Query in Access

(This is a note from Kim Nystrom)
  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".