Cannot open CDS or see the drive in My Computer

Can anyone shed some light on this? When I put in some software cds they
don't autoplay even though the settings are right for that and when I go to
Computer the drive does not show up there it only has C Drive. This is doing
my head in I've only had the computer for a few months it came with Vista
basic installed already on it so I don't think I can uninstall and then
re-install, any help will be very much appreciated.