>I am wanting to use the Access Report engine via OLE automation.
>I want to create a query in VFP, create the access.application and create and ADO record source from my query and pass a reference of it to Access. I have 2 questions. Does Access97 do ADO? Has anyone done this?
>
>Thanks
Yes it does. And is not that difficult to pass the recordset around. After you have your ADO recordset in VFP, just pass it as a parameter to a function in Access that accepts it and passes it to the report. I haven't tried to use ADO with an Access report, but I'm sure if it cannot be used directly you can write to a temp table and use that as source.