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
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com