The working drive for SFC3 is stored in the registry under HKEY_LOCAL_MACHINE/SOFTWARE/Activision/Star Trek Starfleet command III. If you don't know what I'm talking about forget it, you could do serious damage.
Uninstall, and reinstall from the CD drive you want to use.