ADO and SQL Server

[Newbie]

Hi,

I have an XP database that returns a recordset based on a stored procedure
in SQL Server 2000

Occasionally I get a time out error that then makes the dbase crash and
burn.
Where is the timeout period set?
What is the best way to get around this problem? A timer on the form or is
there something else that is better?

 

[Naresh Nichani MVP]

Hi:

I assume you are running ADO code to run the stored proc. The ADODB
Connection Object has a ConnectionTimeout property set in milliseconds - you
can increase this.

Regards,

Naresh Nichani
Microsoft Access MVP