Microsoft KB Archive/123713

= ACC2: Report Based on Fast Query Seems to Run Slowly =

Article ID: 123713

Article Last Modified on 6/25/2002

-

APPLIES TO


 * Microsoft Access 2.0 Standard Edition

-



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

Additional query words: jet25 slow

Keywords: kbbug kbusage KB123713

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.