Ms Access Pass Through Query to ODBC or SQL Server Connect

Microsoft Access Pass Through Query is the method that allows you to execute SQL statement directly using external database such as SQL Server. Before we get started with Pass Through Query, first you need to set up the DSN from ODBC data source: 1. Go to Start > Control Panel. 2. In the Search Box,

source http://database.access-templates.com/ms-access-pass-through-query-to-odbc-or-sql-server-connect.html