ACC2: Report Based on Fast Query Seems to Run Slowly

ID: Q123713


The information in this article applies to:


SYMPTOMS

Novice: Requires knowledge of the user interface on single-user computers.

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:

Q122927 WX1124: Microsoft Access Version 2.0 Service Pack

Additional query words: jet25 slow


Keywords          : kbusage RptOthr 
Version           : 2.0
Platform          : WINDOWS 
Issue type        : kbbug 

Last Reviewed: April 8, 1999