Denver Area Access Users Group

General Meeting Presentation

Tuesday, August 4, 2015

Patrick Headley

Use Pass-through Queries for a More Robust Database Solution

Patrick Headley

You’ve created a database application in Microsoft Access and you used a database server, as the back-end in order to achieve a high level of performance but there are still some complex processes in your application that take a long time to complete. For example, maybe there’s a report with a large amount of aggregated data that takes a long time to display, even though you used a server View for performance. Don’t lose hope. Maybe all you need is a Pass-through Query and some code.

In this presentation you will see how Microsoft Access Pass-through Queries are different from the queries that you normally see in Microsoft Access and how they can make even the most complicated features of your application run quickly. While the focus of the presentation is on Pass-through Queries, you will also see some database server code. This presentation begins with some basic query concepts and finishes with some complex procedures that take advantage of Pass-through queries. So, whether you are new to Microsoft Access or a seasoned pro, there is something in it for you.

Patrick Headley is the President of Linx Consulting, Inc., serving as a database, web and application developer/consultant. He uses various database and application development products, including Microsoft Access, Microsoft SQL Server and .Net. Patrick creates databases and applications from the ground up and also fixes and improves upon databases and applications that were written by other developers; working for for-profit and non-profit organizations. Patrick is the current Web Master of the Denver Area Access Users Group and a Past President of the group. He can also be seen on a regular basis at the DAAUG lab meetings. Please visit the Linx Consulting, Inc. website at for more information.