Originally Posted by
Bucko
Here is what was said by an MS engineer.
"We have identified an issue in the Access source code that is contributing to the cause of the intermittent query performance problem you see in Microsoft Access when using Windows 7 machines.
Due to efficiencies built into the newer operating systems, as well as efficiencies in many newer machines, resource management is vastly different from the time when the database engine code for Microsoft Access was developed. The Microsoft Jet Database Engine code, on which the Access 2007 and Access 2010 Database Engine was based, was developed to work around resource limitations in older operating systems. Due to the recent changes in resource management, we are finding that the older approach to resource management is resulting in the intermittent query performance issues. Our developers are currently exploring an approach to resolving the issue in the source code for the Access Database Engine."