How to Create Pass-thru Query in Access
(This is a note from Kim Nystrom)
- from query design view select:
Query > SQL Specific > Pass-Thru
- from query design view select:
View > Properties
- 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".