I'm running a query in Access that runs against an Oracle database.  In 
testing I would disable my network connection  during the query to test 
what would happen if the network would fail during this query.  Access 
freezes and never comes back.  I was wondering if there was a way to fix 
this, or if anyone has had the same expierence.

Thanks

I'm assuming you're running the query off a front-end form.

I'm not sure if it will work for your problem, but you can try using 
the "DoEvents" function to give some time to the OS so that you can make a 
Cancel button work on your form.  Another suggestion would be to have it 
time out automatically (end the query) after a certain time (like 10 
mins).  

Hope my suggestions help


Dave


> I'm running a query in Access that runs against an Oracle database.  In 
t> esting I would disable my network connection  during the query to test 
w> hat would happen if the network would fail during this query.  Access 
f> reezes and never comes back.  I was wondering if there was a way to fix 
t> his, or if anyone has had the same expierence.

> Thanks