I had the same problem with Windows 7 64, the game would install but CC wouldn't work and gave me the same message. There is a way around it but it's not practical for most people. You either need the capability to dual-boot or have/know someone with an old computer with a compatible version of Windows installed (95, 98/SE, ME). You first need to install the game, then install CC and then run the 3.1 patch. Once you have done this, you should burn the entire install folder to a CD. That way you will always have a fresh copy and never have go through this again. The rest is easy. Simply copy and paste the folder from the CD to your desired location on the computer of your choice and make a shortcut to the "TotalA.exe" file. The game should run just fine, if not, try compatibility mode. Enjoy.
Best option is like Sir said, get it at GOG.com ...Best $5 I ever spent. It also comes with the expansion loaded in the download as well. GoG also has many Win 95,98,and XP 16/32 bit games that have been made compatible with Vista,7 and Win 8 64 bit OS. You can also download editors for Units/Mods and Maps @ www.tauniverse.com
Peace all