I am using data base objects(DAO) and connecting to Msaccess.I executing a long query,WHAT SHOULD I DO TO STOP THE QUERY IN THE MIDDLE OF ITS EXECUTION.
NOTE:
I am not using ODBC DIRECT or ODBC.
with regards
Printable View
I am using data base objects(DAO) and connecting to Msaccess.I executing a long query,WHAT SHOULD I DO TO STOP THE QUERY IN THE MIDDLE OF ITS EXECUTION.
NOTE:
I am not using ODBC DIRECT or ODBC.
with regards
You can't cancel a Query, once it's launched your application loses control until the Query returns.
What you could do is set the QueryTimeout Property of the Database to a Specific Number of Seconds, at which point it will Timeout and Give a Trappable Error if the Query doesn't return.
------------------
Aaron Young
Analyst Programmer
[email protected]
[email protected]