Timeout Expired Message

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have a report that gets its data from executing a stored procedure on a
SQL server 2k machine. However, it sometimes reports a "timeout expired"
message.

Is it possible to "trap" this error and report it back to the user (i use a
custom form with a docmd.open command that just closes the report when this
error occurs, and i dont think the on error goto works for this).

Also, is it possible to increase the timeout counter (or disable it
completely)? I know it wont go to infinity because of the coding for the
stored procedure. Just sometimes the server is slower than others.

thanks for any and all help!
Ben
 
Did you ever get an answer to your question? I have the exact same problem
on a contract I'm working on, and haven't been able to figure it out yet. I
didn't do the original report, and for the time being just need to get it to
run (I will optimize it later).
 
nope. havent recieved an answer yet. what i did was write a new stored
procedure that created a table and set the timeout on the running of that
stored procedure to 0 and then just based the report off the table
 
I can't seem to find where to set that. I have gone into design mode on the
stored procedure but there is no properties access.

I have tried using a view, and although there are properties when I bring it
up in the designer, there is no timeout field.
 
Sorry, i didnt make the last comment clear. I can set the timeout value for
executing a stored procedure through msaccess's vb code, but not for running
a report.
 
Back
Top