Search results for query: *

I have a 100k record table in Access 2002 with a new field which needs to be updated with a sequential number. Basically, I need to insert the rownum into this new field. I do not want to do this manually. I'm hoping for an update query or script to do this. Any ideas? Thanks in advance! -Andrew

Dave -- Sounds like our machines have the same problem. I did not find a solution. I ended up wiping the partition and reinstalling the OS. That fixed it. -andrew

John -- thanks for the tip, but I don't think it's the virtual memory. First of all, I have 390MB RAM. Also, this problem started happening out of the blue.. Prior to this, my machine ran fine. In fact, less than half of the memory is used when this occurs. Both IDE channels are setup to use DMA.

I should have explained the problem more better...sorry. The problem is that after booting up, the processor stays pegged at 100% until the machine is powered down. In performance tab in task mgr, the processor stays at 100%--even after all processes have been started and the boot sequence is...

I forgot to mention that the process using up the CPU time is the System Idle Process, which has me confused. I have tried killing every possible non-critical process to see if I could unlock the CPU, but that hasn't worked.

The processor on my Win 2k laptop is completely pegged at 100% at start up sometimes. It appears to be random, but about half the time I boot up, my processor is floored. The work-around is to simply reboot. This works almost every time. I have checked all Startup folders as well as the run key...

That worked. Thank you very much Terry! Have a good one! -andrew

Hello everyone. I know this has been discussed previously, but I'm have having issues with the following update statement: UPDATE CPES_AllItems SET ItemTypeID = (SELECT basicinfo.BasicInfoItemtypeID FROM basicinfo, CPES_Allitems WHERE basicinfo.basicinfoid =...