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