I have an application coded in C++ using ADO. It has a very simple Recordset that opens a table and gets only one record without any filtering. The CommandTimeout is set to 600 (seconds). Once a while I get a timeout error generated by Requery() that puzzles me. I cannot imagine how Requery (i.e. close the Recordset and open it to get only one record in my case) can take 600 seconds.

Any clue would be greatly appreciated.

Re: Timeout for Recordset.Requery method

Adamus Turner

Sounds like the table is locked (another query is accessing the table).

Set the commandtimeout = 0 but I still think the table is locked.