Special Edition Using Access 97, Second Edition

Using Access 97's SQL Pass-Through Queries

SQL pass-through queries allow you to write queries in the dialect of SQL used by the server RDBMS. SQL Server, as an example, lets you write stored procedures that you can execute by name, instead of by sending individual SQL statements to the server. Executing a stored procedure query is faster than executing the query through the Jet database engine because of reduced network traffic and faster execution of the query by the server. (Stored procedure queries are precompiled by SQL Server.) You also need to use SQL pass-through if you want to take advantage of special Transact-SQL reserved words not included in Jet SQL. In many cases, SQL pass-through queries execute faster than queries that use Jet's ...