When all the rows of the recordset will be used (when you through all records, when displaying into a grid, when printing, ...), you better use a client-sided cursor.

When you display some records and give the user the chance to cancel operation before working with the end of the recordset, you may use a server-sided cursor (this way, not-used record will not cross the wire).


>I need suggestion for the value of cursorlocation, when should I use aduseserver or aduseclient? or in what condition should I use aduseserver or aduseclient? TIA
>
>
>Teddy