MS-Access as extern report generator via ActiveX and ODBC RRS feed

  • Question

  • A little bit complicated application. I try to explane it:

    I use MS-Access as an extern report generator. I fill in my program (C++) over a ODBC Connection the data for the report. Then I open Access via ActiveX and start a Report resp. a Pdf-export for data stored before.

    This work for single report. The main time takes of this process takes the opening an closing of Access. For generation 1000 of reports this is a wasting of time. So my idea was to open Access only once and start the report generator for every single report. This is indeed much faster.

    The problem is, that the reports are mostly the same (with the same data shown). Here are the steps

    • Open Access
    • Save data via odbc
    • Generate Report  (is ok)
    • Save new data via odbc
    • Generate Report  (shows data from previous report)
    • …. and so on …
    • close Access 

    It seem that the saved data via ODBC has not really reached the database – reports system yet.

    Any idea how to solve this   - something like   flush ????


    Friday, July 3, 2020 8:19 AM

All replies

  • "Save data via odbc" seems to indicate you fill a "report table" with data before running the report.

    If that is so, run a Delete statement to clear out possible previous data within each iteration.

    -Tom. Microsoft Access MVP

    Friday, July 3, 2020 5:36 PM