anand
Dec 14th, 1999, 01:47 AM
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
Aaron Young
Dec 14th, 1999, 03:17 AM
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
aarony@redwingsoftware.com
adyoung@win.bright.net