Program running forever, but won't use CPU.

[StevePupel]

I'm trying to run some VB code (in an Access module). The code executes for 10 seconds or so, and then Windows XP robs it of any CPU. I've tried (many times) using task manager to set the priority to high or real time, but still MSAccess shows as using only 2 or 3% of cpu.

I've got in intel core 2 due, running Windows XP SP2.

I've got a table with about 2 million rows. When I try to append the 2m into another table with an append query, or if I burn through the table with a do loop in VB using recordset.append and then recordset.update it takes forever (hours). What burns me up is that the CUP sits there near idle, varying from 2 to 4 pct usage.

Thanks for any ideas..

Steve

 

[RuralGuy]

Most of what you describe has little to do with the CPU and a *lot* to do with the disk system. Basically it should be disk bound. You could be getting close to the 2GB limit of Access where things slow down to a stop rather dramatically.