Windows 7 Explorer not showing drive while it shows in computer management

It is possible the machine having problems has a weak power supply or multiple USB devices attached.

It is also possible the machine’s USB port has an oxidized connection.  If so it can be cleaned very gently with a piece of emory paper.