Can I play Star Trek: Birth of the Federation any more?
It seems to be still available from Amazon (albeit very expensive if you want it new.)
Seeing it is a DirectX 6 game, I assume it still runs on Windows XP (however, it probably won't run on the 64-bit version)
It even runs on Win7, 64bit. At least, it works on my machine.