• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 12. Advanced Query Concepts > Pass-Through Queries

Pass-Through Queries

Pass-Through queries allow you to send uninterpreted SQL statements to your back-end database when you're using something other than the Jet Engine. These uninterpreted statements are in the SQL that's specific to your particular back-end. Although the Jet Engine sees these SQL statements, it makes no attempt to parse or modify them. Pass-Through queries are used in several situations:

  • The action you want to take is supported by your back-end database server but not by Access SQL or ODBC SQL.

  • Access or the ODBC driver is doing a poor job parsing the SQL statement and sending it in an optimized form to the back-end database.

  • You want to execute a stored procedure on the back-end database server.

  • You want to make sure the SQL statement is executed on the server.

  • You want to join data from more than one table residing on the database server. If you execute the join without a Pass-Through query, the join is done in the memory of the user's PC after all the required data has been sent over the network.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint