>>>Is there an easy way in VB to create VFP tables out of VB ADO recordsets so that the data can be viewed in VFP?
>>>
>>>Or is there way to use the VB ADO recordset directly from VFP?
>>>
>>>Thanks.
>>
>>
>>Huh? What is the backend database you are using? I'm sure you can open it in VFP as well.
>>
>>Wayne
>
>The backend is SQL 7.0, but that's not the answer. The ADO recordsets are created in VB and are living as middle tier objects. The question is how to use them in VFP( for some simple browsing,testing and other VFP stuff) without recreating the recordsets from scratch in VFP via a connection to the backend.
>
>We believe that the answer is...it's not really possible. We do know how to get the data from the server via VFP, but that's not the question<s>.
>
>Thanks for the reply...


It's possible in a couple of ways. An ADO recordset can be passed to an OLE Object in VFP 6, and viewed/manipulated in the object, or you can create an OLE object in VB, and call it from VFP to have it return a recordset object. Once VFP has the RS object, you can maniplate it from there using its properties and methods, or convert it to a dbf using your own routine, or one of several generic ones that are available as freeware.

I hear ADO 2.1 has methods to save and restore RS objects to file. Using htese, you could save the RS to a file, and restore it from the file in VFP. I can't tell you the syntax, because I haven't used these methods yet.