MS Access is front end, and MySQL is the backend database. I have no linked in tables.


During an ADO.EXECUTE. Does the SQL just merely passes to the backend and let MySQL does all the processing and just interperts the result from backend?

Or does the ADO.EXECUTE pulls in data from backend and lets the JET engine do the processing?


If the ADO.EXECUTE passes sql to backend, then does this mean that it really is a form of "pass through query".