Would this rig last?

For about 5 years from now? Just guess please :) I would upgrade if needed though...

PROCESSOR Intel® CoreTM2 Duo Processor E6600 (4MB L2 Cache,2.4GHz,1066 FSB)
OPERATING SYSTEM Genuine Windows VistaTM Ultimate
MEMORY 4GB Dual Channel DDR2 SDRAM at 667MHz - 4 DIMMs
HARD DRIVE 1TB Serial ATA 3Gb/s Hard Drive (7200RPM) w/DataBurst CacheTM
VIDEO CARD768MB nVidia GeForce 8800 GTX

people are using 5 years old computers all the time, they are usually old people that play suduko and freecell.

it may last five physical years, but if it probably will last about 3 years for gaming 

I've had my 7800gt since it came out which was about a year and a half ago about.

It's still going. It runs games on high, but the frame rates aren't as nice anymore. So I'm guessing with more graphical advancements in games it will be on the medium end. I'm alreay sick of it and waiting for the 8900GTX to upgrade. lol

That's basically a top of the line PC. You should be able to get at least 3-4 years out of it, maybe more if you overclock or don't mind tweaking and lowering settings. Until a few months ago I was still using a P4 2.8 Northwood with an X800Pro that I originally built back in 2003.