I'm running Office Access 2003 on a Pentium 4 3Ghz with 1Gb memory. When running code in the modules section of Access, I can never get cpu usage above 50%-51%. It seems like Office has throttled itself not to use the cpu. Similar apps I've written in Access 97 run much faster. I've checked all over the net for an answer. Before I uninstall the 2003 version and go back to Access 97, I thought I'd post here to see if I've overlooked anything.
Basically I just have various vb code that iterates through recordsets adding or changing records. There can be hundreds of thousands or a million records depending upon the database or table involved. Access 97 can process around a hundred records a second and Access 2003 can process about 2 records a second, which isn't really viable for me. In Access 97 I can peg the processor. In Access 2003 it never goes above 50% or so. Seems like, somehow somewhere, Access or Jet is throttling it's cpu usage. I've tried simple stuff like increasing threads in the registry, but doesn't really attack the problem. Have I missed some basic configuration setting?