Timeout error

[Rajat]

Hi,

I keep getting the following error:

'-2147217871 (80040e31)':

Timeout expired

I have changed the timeout setting on the ADP to 30
seconds (max value).

And have set the value to 0 in the form which means max
as well.

Pls help!

Thanks,

Rajat

 

[Roland Wabersich]

Hello Rajat

I had a similar problem in the VBA code. I did set the ADP timeout to 0 and
changed the commandtimeout property of my current connection right before I
opened a recordset to 0 as well. This worked!

See a sample:

Set rst = New ADODB.Recordset
gcnn.CommandTimeout = 0
rst.Open strTable, gcnn, intCursor, intLock

Where gcnn is my current connection.

Roland