A blog entry on Wired published a good animated overview of how a "Buffer Overflow" attack works. In light of the new "Conflicker worm" that is gaining attention, this blog does a good job of explaining in a short, simple, interactive way, how buffer overflow attacks work.
http://blog.wired.com/27bstroke6/2009/03/conficker-how-a.html