• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

8. Programming > 83. Override the Timeout Interval

Override the Timeout Interval

In a busy network environment, a little patience is sometimes necessary.

When using Access to connect to an external database, performance depends on a number of factors. One of these is the network—specifically in regard to bandwidth and traffic. Bandwidth might be constant, but add in the dynamic of network traffic, and you often don’t know what to expect.

To be on the safe side of having your processing complete, even if it takes a while longer, you can turn off the ADO CommandTimeout property. The default is for a timeout to occur after 30 seconds. This means that if the server has not communicated back to your application in 30 seconds, your application assumes a response isn’t coming. You might then see a timeout message such as the one shown in Figure 8-19.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint