If windows detects the drive when you plug it in, but it doesn't show up in "my computer", you can try this.
At a command prompt (may need to run as administrator) type in:
set devmgr_show_nonpresent_devices=1
start devmgmt.msc
Then you can use "Show Hidden Devices" in the Device Manager window and see what pops up. The main groups to target are going to be "Disk Drives", "Storage Volumes", and "USB Controllers".
I usually find them in the USB Controllers area. Anyhow, delete all entries like "mass storage device" or similar, then reboot. You should get the "new hardware device found" balloon popup when you insert the drive or any other device you just removed from the device manager.