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

Pass-Through Queries

Pass-Through queries enable 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