If a Microsoft Access form that is using the Adaptive Server ODBC Driver to execute a query that returns large result set is closed before the entire result set is processed, Microsoft Access remains unresponsive until the ODBC Driver completes processing the entire result set.
In version 15.7 ESD #7, a new connection property CancelQueryOnFreeStmt addresses this issue. When this connection property is set to 1, whenever a form is closed, the Adaptive Server ODBC Driver cancels any pending results and returns control to the Microsoft Access application immediately. When set to 0 (default value), there is no change in Adaptive Server ODBC Driver behavior.