Well as you haven't mentioned what operating system you're using, I'll assume XP.
Click on Start/Help and Support
In the search box, type: Autoplay
Click the arrow to the right of the search box
Under Pick a Task (left column) click Change how your computer handles multimedia comment
Follow the instructions in the window on the right