I have a report with the recordsource set to the name of a valid stored procedure. I am assuming that in this situation, the connection that is used is currentproject.connection and that the timeout value for executing this report's recordsource is 30 seconds, the value of currentproject.connection.commandtimeout.
On an XP machine (using Office XP with SP1 applied), the report timeouts at 30 seconds. On 95/98/Me machines (using Office 2000 with SR-2 applied), the report executes just fine and, by the way, takes longer than 30 seconds to run.
Is it possible to change the value of currentproject.connection.commandtimeout to 0 so I don't have to worry about this timeout? I tried through code with no success. Maybe there is another perspective to try ... help! Thanks!