CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. May 22nd, 2001, 05:17 AM #1
    dave seddon
    dave seddon is offline Junior Member
    Join Date
    May 2001
    Location
    Lancashire, England
    Posts
    16

    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

    Reply With Quote Reply With Quote
  2. June 7th, 2001, 11:21 AM #2
    Spectre5000
    Spectre5000 is offline Member
    Join Date
    Apr 2001
    Location
    Wisconsin, USA
    Posts
    150

    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.

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules




Click Here to Expand Forum to Full Width

Featured