Passing ADO recordset from VB to Access 97

[dave seddon]

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

[Spectre5000]

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.