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).
for sure multi core support is a must in this age
I would really like to see MS Access gain Multi Core support, like others have said. Some of our reports takes a considerably long time to run. Even if the program could use more memory and the full power of a single core would be some help.
Yes please!! We use Access quite a bit and some of our queries/reports take hours to complete. Seems odd to me that in this day and age it wouldn't support multi core. Most computers have had multiple cores for several years now...take advantage of them...you're nerfing your own product by not doing so
Bob Alston commented
Please make Access able to make use of multiple cores as almost all PCs/lapptops now have 2 or more cores.
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.