I would suggest that you use the error handler, in the error handler check the err object for the ADO timeout error number, you can then set the CmdSP.CommandTimeout to...

A very useful article. I would just like to comment on the area of Page splits that was discussed. To get around the page split problem to a degree use...