Data Environment / Data Report Problem
I have written a program in VB6.0 and within it I have created a data
environment connected to an MS Access database. Within the data environment
is a stored command which I use to retrieve information for a report.
When I run the report I first run the stored command passing a value as a
parameter to get the correct information. Then I run the data report which
is linked to that command (datasource and datamember properties). The data
report can either be viewed in preview mode or printed automatically.
I have a customer who is using the program and is experiencing a problem
where the data environment is taking upto 40 seconds to run the command and
retrieve the information for the report. Normally it takes 1-4 seconds on
various other PC's that we have tested it on.
Does anybody know what might cause this? The customer has Windows Millenium
running. The development PC is running Windows XP. The software has been
tested on Windows 98 and works fine.
Any help much appreciated.
Andrew
