Look at VFPCOM.DLL in which you can convert recordsets to DBFs and vice-versa. You could convert your recordset into a local DBF.
>
>I use ADO to connect to several type of data providers. Now that more and more users are using the app it seems to be getting slower.
>
>Is there a way to get an ADO recordset and save/keep it live on the client so as to minimize the trips to the server?
>
>Thanks,
>Michael
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05