The Unbound Form and Pass-Through Queries
The examples in the previous section all use ADO code and SQL statements to retrieve and update table data. An alternative is to use a stored pass-through query to accomplish the same results. Pass-through queries provide an efficient means of retrieving and updating SQL Server data. Pass-through queries require two pieces of information: They require the SQL statement that you want to execute and connection information for how to connect to the SQL Server.
Using a Pass-Through Query to Populate the Form with Data
The examples that follow use the frmCustomersPassThrough form located in the Chap13Ex database. To run the examples, you must have an ODBC datasource called NorthWind that points at the SQL ...
Get Alison Balter's Mastering Access 2002 Enterprise Development now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
