1. Open 'My Computer'
2. Right click on the device (CD Drive/USB Camera)
3. Hit 'Properties'
4. Click the Auto-play tab
5. Go through each format in the Drop down menu (Music File, Pictures, ect) and then select "Prompt me each time to choose an action."
You'll have to do this for each device.