P
PhilK
We have a large database (Access 2007 on XP) with a data table containing
over 10 million records. We have a series of queries and observed that one
query failed to return all records - It stopped after returning exactly
2,886,000 records. Rerunning the query produced results from all 10 million
records.
We made a copy of the database and issued the same set of queries.
Sometimes the set of queries produces the desired results from all data
records, while other times one (not always the same query) will truncate
after processing exactly 2886000 records.
Why does this happen and what can be done to guarentee good results.
over 10 million records. We have a series of queries and observed that one
query failed to return all records - It stopped after returning exactly
2,886,000 records. Rerunning the query produced results from all 10 million
records.
We made a copy of the database and issued the same set of queries.
Sometimes the set of queries produces the desired results from all data
records, while other times one (not always the same query) will truncate
after processing exactly 2886000 records.
Why does this happen and what can be done to guarentee good results.