How to stop the query processing

  • Thread starter Thread starter Fred Fortin
  • Start date Start date
F

Fred Fortin

I run some report in access 2000 that are based on ODBC
connexion to SQLserver7. I want to know How can I stop a
report(process) while it seem not responding for more than
30 minutes. It seems that if I do a dirty shut it slow all
other user until we stop/start sqlserver.

Thanks
..
 
Can you set the ODBC Timeout to a shorter time?


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
they are at 60 seconds, want I want to do is to have a hot
key like F10 to stop the report processing

Thanks
 
I think you could create a break routine within the report process. When
the report opens, open a dialog box.with a cancel button. (Don't use msgbox
for this, or the processing will stop, while it waits for a response.)

Throughout the report's event properties, put a check to see if the user
clicked the cancel button. (This actually requires a class module.)

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top