Alright, heres what I did to fix my "Game freezes, sound loops, windows error box then pops up and I get booted back to my desktop" problem.
I went into my systems BIOS (the screen you get when you press delete when your computer is checking the memory at start up)
I went to check my AGP apature size, and saw that it was set at 64 mb not the 32 mb I have on my video card. Very interesting I thought, so I set it back down to 32, saved the changes and ran MOHAA, and whadda ya know, it worked.
So basicly, just set your AGP apature size to the same amount of v-ram you have on your video card.

hope this helps.