D
Doug
A97/ SR2/ SP3, SS2K/SP3, Win2K. SystemMax 1ghz, 256mb.
A report that runs daily is missing SQL Server data, but
not Access data, maybe once or twice every few months.
Restart the app and the SQL Server data appears. Again,
the Access data is never missing.
There is never an error message. Only working with a
handful of records to maybe 800 records maximum.
The client's IT staff believe only the SystemMax PCs are
problematic and don't remember having complaints from
staff with Dells. A search found a couple of similar
problems seemingly solved by adding more memory.
If anyone has an idea what might be happening or can
suggest a test, please enlighten me.
For what it's worth, this is the query process:
I run DAO against a pass-through query (which runs against
a stored procedure which selects a small result set of
summarized detail data) and add another few bytes then
write to a local temp table. Next step opens the daily
report which has a qdef as recordsource. The qdef joins a
linked (Access) table to a derived table (UNION 12 linked
Access tables plus the local temp table containing the
server data).
A report that runs daily is missing SQL Server data, but
not Access data, maybe once or twice every few months.
Restart the app and the SQL Server data appears. Again,
the Access data is never missing.
There is never an error message. Only working with a
handful of records to maybe 800 records maximum.
The client's IT staff believe only the SystemMax PCs are
problematic and don't remember having complaints from
staff with Dells. A search found a couple of similar
problems seemingly solved by adding more memory.
If anyone has an idea what might be happening or can
suggest a test, please enlighten me.
For what it's worth, this is the query process:
I run DAO against a pass-through query (which runs against
a stored procedure which selects a small result set of
summarized detail data) and add another few bytes then
write to a local temp table. Next step opens the daily
report which has a qdef as recordsource. The qdef joins a
linked (Access) table to a derived table (UNION 12 linked
Access tables plus the local temp table containing the
server data).