Will powerful memory AUTOMATICALLY overclock my computer?

Hi guys, i'm planning on purchasing a Kingston HyperX DDR-400 1GB for my Dell Dimension 2400. The HyperX range for Kingston memory has very aggressive and powerful timings and settings, timings being 2-3-2-6-1.
I'm unsure whether my Dell 0G1548 motherboard is powerful enough for these settings. Also I do not plan on manually overclocking my computer. So what I was wondering was that if I install this powerful memory in my computer, will it
(a) the memory will run at the published speed/timings by automatically overclocking my Motherboard to achieve these timings.
OR:
(b) the memory will run at a lower speed and less powerful timings because of the motherboard's configurations and settings.

I really don't wish to overclock my PC, also I'm unsure whether there is anything as memory 'automatically overclocking' a computer, since I've heard that overclocking is done manually.

Really would appreciate the help!

Well according to the dell service manual for the 2400, I dont think this will be a wise upgrade. The system uses an 845GV chipset, which will only support DDR 2100 or DDR 2700, so DDR 3200 (like what you want to use) will be forced to run at a slower speed (333mhz vs 400mhz) and thats before the timings even come into play. This motherboard will not offer you the ability to tweak your timings and I dont think off the bat it will let you run such aggressive settings.

So basically if you put this ram in the system should work just fine, but you will not be taking advantage of the quality. If you already have the ram or are able to get it for cheap, then its ok...but if you are looking to buy right now then I wouldnt bother. look at something like this 1gb kit from newegg for $36 or perhaps look at some of the 2gb kits (the maximum your pc will allow) if you think you need more than 1gb.

Well then what kind of memory should I purchase? I can't buy Knigston's system branded memory since that is far more expensive than HyperX. And I don't really think I'm comfortable with ValueRam since the timings are probably poorer than my computer's config. If there are other brands, please advise.

well in your case you really dont have to worry about it, you will be benefiting from the increase quantity of ram (if you are using the default 512mb config) by upgrading to 1gb. There is nothing wrong with value ram, unless you really wanna go nuts with overclocking because thats really where you start to see the investment paying off. If you compare basic value ram to premium ram of the same speed - only with tighter timings, you really dont stand to gain much in terms of real world performance.

At this point you will be held back by your cpu and video card before the memory really becomes a significant worry area. These days you want to have at least 1gb of ram, ideally 2gb for most modern games and applications....but like I said, no point dropping big money on it since your next PC upgrade would likely require DDR2 or DDR3 memory, so I'd stick with the lowest cost you can to get this system up to where you want it to be...but dont bother paying top dollar because these days $150 will get you a new dual core processor, a solid motherboard and 2-4gb worth of ram. And right there you have all the major components you really need to buy for a new system. So I really would advise against dropping anything more than $50 on some new ram because it really wont go as far as $50 will towards a new system