Sorry for the wait
Omlet, just came back from a hot shower and meal.
We'll give the ram frequency set to [1067] or 5.33x in your BIOS under 'AI Tweaker' another try but this time with ram voltage at 2.3v. Maybe this time you will not get BSOD when stating Windows now that you have the BIOS updated to the latest and ram moved to slot 4 for over DDR2-800 compatibility. I did not advise you to update the BIOS and move the ram to slot 4 before running Memtest86+ first for one reason, I just wanted have a degree of certainty that your ram was not faulty. A popular term for this would be 'if it ain't broken, don't try and fix it' but in your case it's not broken just not working properly. I like to call this marketing but others may refer it as not having a girlfriend for too long.
All joking aside, try the ram frequency set to [1067] with ram voltage set to 2.3v and let us know your results.
Edit: If you still get BSOD, here are the instructions on how to overclock your ram using an increased FSB:
Under 'AI Tweaker' in your BIOS,
- First set your ram voltage to 2.3v exit and save and re-enter the BIOS.
- Change you "FSB Frequency" under 'AI Tweaker' in your BIOS to 250 FSB, this gives you an effective DDR2-1000; do not save and exit yet.
- Change back the "DRAM Frequency" under 'AI Tweaker' in your BIOS to 800 (4x), this is used as a multiplier for your changed FSB Frequency so your ram can run effect at DR2-1000 speeds; again do not save and exit yet.
- Change your "CPU Ratio" again under 'AI Tweaker' in your BIOS to 9.5x, this gives you 2.375Ghz which is very close to your real 2.4Ghz Phenom Quad; again do not save and exit yet.
- Change your "HT Link Speed" under 'AI Tweaker' in your BIOS to 1.4Ghz (7x), this gives you a 1750Mhz effective Hyper Transport which again is very close to your default 1800Mhz HT; again do not save and exit yet.
- Change your '"CPU/NB Frequency" under 'AI Tweaker' in your BIOS to 1600Mhz (8x), this gives you a 2000Mhz effective CPU/NB Frequency which is over your default 1800Mhz but helps with ram overclocking; do not save and exit yet.
- Increase the "CPU/NB Voltage" under 'AI Tweaker' in your BIOS by .1/.50 which ever you have in you BIOS that is smaller between the two, this voltage change helps with the increase 'CPU/NB Frequency' and also helps with overclocking the ram beyond DDR2-800 speeds.
Finally, double check all the above mentioned changes and save and exit. Start Windows and let us know your results again.