Have you tried making a start up disk? Of course that is assuming that you are running win9x.
Does the cd-rom power light come on when you start the system? If it doesn't you could have a loose power connection.
Is the Cd-rom listed in your hardware?
start-settings-control panel-system?
Need more information to help troubleshoot.