MSAccess - CrystalReports - delays -
05-10-2004
, 04:00 AM
Hi,
I have the application (VB6 using RDO) dealing with MSAccess database.
This application use/prints reports build on CrystalReport. Report
data are fetched from AS400 (via ODBC) and put in MSAccess *.mdb file.
In order to build and then print report, application goes for data
only to a local db.
On some PCs all information on the report are shown in a proper way
but on some others there are lacks. I mean the very first data are
missing.
When I put a 'msgbox' (or cause any other delay) between reading data
from server and putting it in local *.mdb file (or even after putting
data to local db) reports are perfect.
Do you know how to solve it? It's quite urgent for me...:-\
Thanks in advance,
Krzysiek
PS. I tried following things but... without effect:
1. The loop:
While rdo_ResSet.StillExecuting
Wend
2. Additional query, to make some kind of connection refresh:
SELECE COUNT(*) from Table_Name
3. Manipulations on PageTimeout, MaxBufferSize |