-
Notifications
You must be signed in to change notification settings - Fork 9
Microsoft Access SQL pass through query
Nassib Nassar edited this page Jun 5, 2020
·
1 revision
- In the Access top menu, click “create” , then “query design”, close the “show table” window that pops up, and then click the “pass-through” button in the top menu (you are now in the query “design” menu)
- Once you have clicked the “pass-through” button, Access now knows that you will be running a pass-through query. Here you are running SQL code directly on the database server.
- Paste the SQL script you copies from GitHub into the query window
- Click “Run” in the top left corner of your screen
Popup Window:
- Once you click “run” to execute the pass-through query, Access will ask you to identify the data source you’re querying.
- Click the “Machine Data Source” tab to access the ODBC data source you set up earlier. Click on that data source and then the “OK” button.
Next Screen:
- Your query will run and the results should display in the query window