ACC2: Report Based on Fast Query Seems to Run Slowly (123713)
The information in this article applies to:
This article was previously published under Q123713 Novice: Requires knowledge of the user interface on single-user computers.
SYMPTOMS
A report that is based on a query that runs quickly seems to run slowly,
taking several minutes to finish.
CAUSE
In certain queries containing many-to-many join fields, Microsoft Access
can choose an incorrect index when it interprets the query. Using the
wrong index results in poor performance.
STATUS
This problem no longer occurs with the Microsoft Jet database engine
version 2.5, which is available with the Microsoft Access version 2.0
Service Pack. For information about how to obtain the Service Pack,
please see the following article in the Microsoft Knowledge Base:
122927 WX1124: Microsoft Access Version 2.0 Service Pack
| Modification Type: | Major | Last Reviewed: | 6/25/2002 |
|---|
| Keywords: | kbbug kbusage KB123713 |
|---|
|