使用Windows 7的Access 2002查询非常慢 [英] Very slow Access 2002 query with Windows 7

问题描述

我需要帮助解决使用Windows 7的Access 2002数据库中持续缓慢查询的问题。
  我在后端的本地副本中运行临时查询只有表的数据库。对于Windows XP，相同的查询只需2-3秒，而使用Windows 7则需要30-60秒。多个Windows 7工作站都很慢，所有Windows XP计算机都会快速运行查询
。 我甚至在两个工作站上使用JetShowPlan进行比较，并且计划完全相同。在第一个上使用rushmore，在第二个表上使用大约150,000个记录的完整扫描涉及两个表。
即使在Windows 7机器上的XP模式下，查询仍然只需要大约10秒钟。任何人都有任何想法为什么Windows 7上的Access / Jet可能如此之慢？感谢您的任何想法。

I need help troubleshooting consistently slow queries in an Access 2002 database with Windows 7.  I’m running a temporary query in a local copy of a back end database with only tables. The identical query will take just 2-3 seconds with Windows XP but 30-60 seconds with Windows 7. Multiple Windows 7 workstations are all slow and all Windows XP machines run the query quickly.  I even used JetShowPlan on both workstations to compare and the plans are identical. Two tables are involved with rushmore used on the first and a full scan on the second table of about 150,000 records. Even in XP Mode on the Windows 7 machine the query still takes only about 10 seconds. Anyone have any ideas why Access/Jet on Windows 7 can be so slow? Thanks for any ideas.

推荐答案

抱歉，我没有真正的答案，我建议您再次尝试使用Access 2010.运行时是免费下载的。

Sorry I don't have a real answer, but I would suggest you try again using Access 2010. The runtime is a free download.

这篇关于使用Windows 7的Access 2002查询非常慢的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！