FYI, on an Asus AV7333/AthlonXP I wanted to add a third HD as slave to a DVD-rom on IDE2, using the existing 40-wire cable.
BIOS recognised the HD, but Windows 2000/SP4 would not. Only after I changed to an 80-wire IDE-cable AND changed the HD to master AND disconnected the DVD did W2K recognise that HD.
I have to add that the HD in question was setup in another PC, also with an 80-wire cable.