SdmInformatik
May 10th, 2004, 03:41 AM
Hello,
We have an MFC C++ program using an Access database through ODBC. We want to generate some reports and for this we make some calculations and then write these results to a 'report' table in the database. This table can then be read by Crystal and the reports printed.
Our problem is that sometimes the reports contain no data and the reason for this seems to be that the Update call in our program does not immediately write to the Access database but there is a small pause. If we put a delay of 1 second between writing with our program and reading with Crystal then everything works fine.
Does anyone know what is causing this delay or how we can fix it?
Thanks,
Jonathan
We have an MFC C++ program using an Access database through ODBC. We want to generate some reports and for this we make some calculations and then write these results to a 'report' table in the database. This table can then be read by Crystal and the reports printed.
Our problem is that sometimes the reports contain no data and the reason for this seems to be that the Update call in our program does not immediately write to the Access database but there is a small pause. If we put a delay of 1 second between writing with our program and reading with Crystal then everything works fine.
Does anyone know what is causing this delay or how we can fix it?
Thanks,
Jonathan