>Can someone give me some of the Pros and Cons for upgrading to VFP6

You get a chance to discover for yourself, first hand, all the bugs in it! ;-)

Seriously, I always try to wait for the release of a service pack, so the major bugs are taken out. But if you cannot wait... good luck!