Would help to know these things as it might indicate a difference between a hardware or software settings problem.
If you have Nero InCD or Roxio DirectCd stop them loading and get updates - also stop all other media type of software loading using msconfig eg media players, CD burning programs and anything else that uses the CDROM drives
Stop All auto insert notifications and see if this makes a difference
Check to see if you have direct memory access turned on for your CDroms.
If it has always happened then check master slave settings - update mother board and bios drivers.
Here is some link for trouble shooting CDROMs
http://www.google.com/search?sourceid=navclient&ie=UTF-8&rls=RNWE,RNWE:2004-28,RNWE:en&q=trouble+shooting+CDROM
Peter
Microsoft Windows XP Home Edition
2600, Uniprocessor Free
AMD Athlon(tm) XP 2400+,
Bios Settings
IDE Primary Master: MAXTOR 6Y080L0
IDE Primary Slave: None (unable to change to auto)
IDE Secondary Master: CD-RW IDE 5224
IDE Secondary Slave: SONY DVD?ROM DDU1621
Properties for CDWRITER IDE5224
Device Type: DVD/CD-ROM drives
Manufacturer: (Standard CD-ROM drives)
Location: Location 0 (0)
Status: Device working properly
Driver: cdrom.sys
Driver Version: 5.1.2535.0
Properties for SONY DVD/CD-ROM drives
Device Type: DVD/CD-ROM drives
Manufacturer: (Standard CD-ROM drives)
Location: Location 1 (1)
Status: Device working properly
Driver: cdrom.sys
Driver Version: 5.1.2535.0
The problem: when I turn on the PC everything works fine apart from when a CD of any file type is inserted to the CD, it reads lights flickering etc but when the drive is explored it shows nothing on the disc likewise with the DVD?s however if I leave the discs inserted and log off, as I have currently 3 users set up then log back in I am able to explore both drives without any problems, but it is annoying that I have to do this everytime.
Any advice?

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic