Timeout for form bound to recordset

N

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filter main form to records with no related records in subform,maintain updateable recordset 4
ADO and SQL Server 1
record set for pass through query 1
populate form with a recordset 3
Server timeout expired 3
recordset vs collection 2
Bound Form Search 5
Query Timeout error 0

Top