General information
Category:
COM/DCOM and OLE Automation
>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only