there are some ADO downloads (a browser and query analyzer) available that might offer some insight into ADO and VFP COM. The community is also looking at CursorAdapter in VFP 8 (beta) that will certainly revolutionize the way VFP business objects deal with recordsets.

>Hi All,
>
>I've been trying my hand with ADO Recordsets and Com but I've still got some questions and no doubt a whole bunch of misunderstandings about the subject.
>
>
>When is it adviseable to create a client over server side recordset ?
>
>In conjunction with Com Components (middle tier or other) will the recordset always be client side ?
>
>As for locking implications... do I always use optimistic or would you ever use pessimistic with a server side cursor.
>
>Sorry about all the combined questions here. I've been jumping through three different books here and neither of them nail it down. To make things worse I've recently completed the VB 6 exams and boy I'll tell ya... is my mind totally messed up.
>
>
>thanks,
>
>Don