for 'further clarification needed' the reply was:

If requerying is equivalent to closing and opening a recordset, I would think that all other properties would be reset as normal. Is this not the case?

reply:

thanks Clunie...

but msdn help says in the same page that certain properties will not get reset when the recordset is open! is it worth taking the risk?

please advise!
jeyasree.