Quite good !! Just as how filter is useful, so is the Clone method. But we have to remember to set the activeconnection to nothing and then clone the recordset...

I have used command object a lot, mostly in the "right" way that has been mentioned. I think that a clearer example of the wrong way could have been explained....

Good shot at basics of ADO.

Vidya

The article is pretty good for beginners on ADO. I appreciate especially the information given on UDL because not everybody know about UDL and its introduction here is good.

The CursorLocation...