The CD in in the only CD drive we have (mapped to F:)
Whe I activate the CD it says
'Not Ready reading drive G'

G drive (and others are automatically assigned to various removable storage media)

I renamed the drives so the CD drive was now G and it complained about F instead.

At that point I gave up

Any Ideas?

(if it helps the Worms demo runs with no problems at all)

I'm sure I remember this problem, can't remember the solution though I'm afraid. However, running it in DosBox seems to be best, as then you'll get the videos and full sound working too.

Otherwise someone did find a way to get it working straight in XP, if it's any help - http://forum.team17.co.uk/showthread.php?t=26505