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 ????
