timeout error

[gust1480]

Can somebody please tell me based on your experience what would cause a vb program using a database to produce a "timeout error". I find it really hard to track this error cause it just happens.

 

[vb5prgrmr]

Sounds like your ADO command object is timing out. If I remember correctly its default is 30 seconds you can change this in code to a value that you want or you could wait forever if you wanted (not recommended). This can happen, say when you are trying to update a record and someone else has the page locked because of the type of recordset that they have it locks the table/page that you are trying to update or even select from.

Good Luck

 

[gust1480]

Thanks for answering my question. How can I avoid this kind of error to happen? Are there ways?

 

[Abaka]

Make sure all the ADO objects created properly and unload
them properly. check the appropriate event to trap the error
Good luck