There was a CDROM PC game in the mid 90s that I used to play a lot but I dont remember the name of it. It probably came out around the same time as SWAT 3 because I remember playing it around the same time.

The only things I specifically remember is you played some sort of underwater craft and you were fighting off some sort of underwater aliens or civilization. The game was "on rails" in that it would take you from location to location and was also sort of like a full motion video (except obviously not live action since it was underwater and i dont specifically remember there being actors).

Yup. I'm guessing Deadly Tide as well.

Wetlands

Well... it could be Wetlands, but the OP made no mention whatsoever to the superb animation of the cutscenes, something they would not have forgotten. Also, and I may be wrong on this one, wasn't Wetlands just available on floppy disk? I don't recall it being a CD-ROM game.

Echo the Dolphin

It probably is Deadly Tide. I wish GOG had this game I don't remember it being a spectacular game but I would love a chance to actually beat it.

Vote for it.

http://www.gog.com/wishlist/games/deadly_tide

Although I think I remember it being a Microsoft game so the chances of it coming anytime soon isn't likely. :/

Is definitely deadly tide. Thanks! Wetlands looks cool though

*Ecco the Dolphin

Oh good, like I didn't feel bad enough about the bogus post the begin with. :P

The version i got was on CD-Rom. I bought it in the bargain bin at Best Buy for $6.99 around 1997.

hey guys im looking for the name of this game i used to play in the 90's when i was younger what u did was explore underwater in this like mini submarine and u would have a magnet thing to pull up bottle caps and stuff but i cant remember the name of it u could also sell stuff i think but i need to know what the name of it is i want to play it so bad.?!.?!

Sounds like Sub culture to me.

Sub Culture

EDIT: Ninja'ed by iippo

OMG THANK YOU SOOOO MUCH THIS IS IT!!!!!!!!!!!!!!