TDA uses the SQL Pass-Through feature of Access (Jet DB Engine) to execute heterogeneous queries. The query builder prefaces each table name in the query with the ODBC connections string and executes it on an Access connection. Access does all the work of parsing the SQL, connecting to all the required databases, and aggregates the data.
