Missing CD ROM ? and a possible Fix

Well had my PC for a Bit now and found that as i have two drive's one is a fast reading DVD drive and the other is a blu ray Burner  i noticed that the DVD was vanishing 

Nothing showing in the Device manager 

so after trolling the Net i see this is a issue and many have this Now both are Satter 

I Noticed that My Blue ray Drive E: was in Sata 1 and my DVD Drive D: was in Sata 3

Now at this point i must point out this was a Bult computer (wife bought it ) so i did not do the build

so this is How i fixed this swopped the sata cables over then changed the drive Letters 

No messing in the BIOS and no Microsoft Fix 

Basicly Hard drive = Sata 1 Drive C:\

Firts Optical = sata 2  Drive D:\

Secound = Sata 3  Drive E:\

Then also windows sorts the Channel numbers out this only seams to afect sata Optical drives