Passing ADO recordset from VB to Access 97
I would like to know if it possible to pass an ADODB recordset from a VB6 app into Access 97 which can then be used as a record source for an Access report.
The initial data is coming from a SQL Server 7 database using stored procs, and these populate a VB front-end. It would make sense to use the retrived data for the reporting, rather than fire the stored proc again for the report.
Any advice or help much appreciated.
Thanks
Dave Seddon
Re: Passing ADO recordset from VB to Access 97
Create a default table in Access that will contain the data that you are receiving in the ADO recordset, and then create a report that is supposed to use that data. In VB, save the information to the access table, and then trigger the report. This should work.