All queries executed by the Jet query processor must be written using Jet SQL syntax. However, Jet’s SQL syntax is not always the same as the SQL syntax used on your server database. Jet’s SQL dialect is the same, however, regardless of the database it needs to access. This feature can provide significant portability in your code and the ability to seamlessly access heterogeneous data.
By default, the Jet query processor is invoked when any DAO query is executed. In other words, unless you use the dbSQLPassThrough option with the Execute or OpenRecordset methods or create a SQLPassThrough QueryDef object, the Jet query processor will parse and execute the query's SQL syntax, and attempt to perform whatever operations are needed on the workstation and the remote server to carry out the request.