Multi-Threaded Processing in Access 2007?

[RGordon@Harron]

I have searched high and low across the net and on Microsoft and can't find
the answer to what I thought was a simple question. How do I get MS Access
2007 to engage all processors during query and macro execution?

I have migrated a particularly complex process to a server running two dual
core processors and yet the processing when started only utilizes ONE of the
four available processors.

How do I engage those other three processors?

TIA,
Rob

 

[RGordon@Harron]

Thanks; that was what I suspected. I knew earlier versions didn't support
it, but I had hoped that with all the '07 improvements MS had taken into
account the proliferation of dual core processors in most desktops. At some
point all programs are going to be written for multi-core PCs.

We are in the process of designing a SQL Server solution, until then we are
functional with the MS Access processes. I just was hoping to speed things
along in the meantime.

Rob

 

[Tom van Stiphout]

On Mon, 26 Nov 2007 19:09:01 -0800, RGordon@Harron

Access is multithreaded and as such at least in principle it can run
for example a UI thread on a different CPU than a query thread.
Running a single query on multiple CPUs is something even SQL Server
can have trouble with. I think it can only do that in special cases.

Still a good idea to have multiple CPUs: they can be used by all other
50-plus processes that are typically running on a machine.

-Tom.