Results 1 to 2 of 2

Thread: Stopping a Query

  1. Dec 14th, 1999, 02:47 AM #1
    anand
    anand is offline

    Thread Starter
    Member
    Join Date
    Apr 1999
    Location
    Hyderabad,AndraPradesh,India
    Posts
    59

    Post

    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
    Reply With Quote Reply With Quote
  2. Dec 14th, 1999, 04:17 AM #2
    Aaron Young
    Aaron Young is offline
    Guru Aaron Young's Avatar
    Join Date
    Jun 1999
    Location
    Red Wing, MN, USA
    Posts
    2,177

    Post

    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]
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width