OK guys...you need to give more details. A copy of the error message could be a great help, even if it doesn't make any sense to you. There are other people who've had CivIII vs. Vista problems, and might recognize an error report. I'm one of them who had CivIII vs. Vista problems and got it fixed, albeit after 50 days.
First of all, if you can do a clean install of Vista, that may well solve the problem. It did for me. Just make sure you back up all your data first. Including Civ saves.
------
dbslikacheung: It sounds like you install Civ3, and after the installation you cannot launch it. Is that correct? If so, how far does it get in the launch? Nothing at all, splash screen (Tower of Babel), video, or all the way through the video? And what exactly is the error code? With some of this information I may be able to guess further as to the problem.
Also, did CivIII ever work on Vista for you?
-----
Brainiac18: What exactly do you mean by "got into the game"? Did it load up to the main menu, or did it successfully load your saved game file? If the game crashes upon finishing loading your saved game files, you have the same problem I had. I believe it may be something to do with installing CivIII with User Account Control on and then turning it off, but before I found evidence this may be the case I had already reinstalled Windows and got it working again. An error message would help here, as well.
----
Veersw, copy down the entire error next time and post it here. This sounds similar to the ~LSANS.font error (you can search for that), or perhaps a file was accidently deleted/not installed. But it'll help a lot to know which file the text was not found in.
---------
Levent Demir, make sure you have the latest graphics drivers for your card. You'd think a new card would have everything necessary for a 2001 game off the bat, but they may have missed something in the initial drivers. CivIV gave me this problem at first due to out-of-date drivers.
------
I tried Firaxis support myself, but they replied that they don't support the game on Vista. So that, unfortunately, is probably not going to help, unless you conveniently forget to specify the version of Windows you're running.