Here's the problem...
I've recently purchased a new Advent computer, so it's pretty much brand new. I've had to take it back to the store for a replacement ASUS CM1740 because I've had the same problem on both machines!
Some officially made audio CDs aren't detected by the drive (E), they do not appear in My Computer and when the drive is double clicked it simply asks me to insert a disc. The same discs fail to work on both machines, so it looks like it's not software nor hardware that's causing the problem (but idk for sure). I've tried everything I can think of (re-installing drives, changing the Drive letter, trying CDs in other devices like CD player, laptop etc)
I'm running Windows 7 64 bit and my DVD/CD drive is a ATAPI DVD A DH24ABS, there are also two disk drives, a Generic Multicard USB Device and a WDC WD20EARX-00PASBO ATA Device.