Options

The dbSQLPassThrough option passes an SQL statement to a Jet-connected ODBC data source for processing. This is perhaps the option that boosts performance the most. Virtually all Jet functionality is bypassed, and Jet simply retrieves data and buffers it. However, because no keyset is created, the recordset can’t be dynamic, and using this option will always result in a snapshot-style recordset. Also, since Jet is bypassed, there is no syntax checking stage, which means that any command string the DBMS can understand will be sent directly without interpretation.