Multi Threading for MS Access. As we all know ms Access is a single threaded application. If you all remember the fun of seeing, "this program is not responding" during a particularly heavy query or task. Multi threading would add huge value to the speed efficiency and capabilities of this application. I realize it would make visual studio WPF not as much of a stand out but lets be honest Access needs to get some real loving (not silly things like a search bar).
I'm running into a similar situation. Some queries were taking a significant amount of time to run. And when I looked at the CPU usage, it was only showing around 30-35%.
So my initial response to was to look to see if there was something in the OS that was limiting Access to a max % CPU time.
However, after some searches and then discussions on MS community, it was confirmed that Access does not handle threads.
My understanding is that as it is designed now, it will never use more than one core of a multi-core processor.
With multi-core processors being used more and more, I'd like to request that Access be updated to be able to utilized the full CPU capablitity, and not just one core of a multi-core processor.
I understand that from the design / programer perspective this is not trivial. However, to keep a product relavent a structural update is required from time to time.
Any updates that will help to address this would be greatly appreciated.