When our users run reports, they don't always produce the same
results, even though the data has not changed. We have several large
reports containing several subreports. Users can run the report and
the report can have a subreport that shows data. They then run it
again, and the subreport is empty. No error is produced. The problem
is not limited to a specific subreport and can seem to occur
anywhere!?!
We also have instances where forms will display data correctly one
time, and then the next time it can display no data (subsequent
viewings will then show the data correctly again). No error is
produced and the underlying data has not changed.
Our setup is as follows:
* MS Access 2000 Frontend Database using the Access Runtime which is
linked to several SQL Server 7.0 Databases (SP4 installed) on the same
SQL Server. Jet 4.0 Service Pack (SP7) is installed.
* The Frontend application is installed on a Citrix system running on
Windows 2000 SP3.
* All users use the same Access Frontend.
One of my suspicions is that the problem maybe occurring when other
users are running 'heavy' reports at the time, which maybe bogging SQL
Server down at times. Perhaps some soft of time out is occurring,
preventing other queries to not complete. However, I would suspect
some kind of error message.
Alternatively, could it be a problem where users are accessing the
same Access Frontend via several Citrix sessions?
Has anyone seen this type of problem before? Any ideas?