Franco had been the oldest player in the major leagues from 2004 to 2007, and was the last active player who was born in the 1950s. On April 20, 2006, pinch-hitting with one out in the eighth inning against the San Diego Padres, Franco hit a go-ahead two-run home run, becoming the oldest player in Major League history to hit a home run. Franco hit a three-run homer on September 30, 2006, in Washington to extend his own record. It was one of three hits in the game for Franco, who fell a triple short of hitting for the cycle. Franco yet again bested himself on May 4, 2007 when he homered into the swimming pool at Chase Field against Arizona Diamondbacks lefty Randy Johnson – a game in which he also stole a base.
Franco was also the oldest player ever to hit a grand slam, a pinch-hit home run, two home runs in one game, and to steal two bases in a game. On April 26, 2006, Franco became the second-oldest man in MLB history to steal a base, behind only Arlie Latham, who accomplished the feat in a token appearance at age 49 with the New York Giants in 1909. On July 29, 2006, against the Atlanta Braves, Franco became the oldest player ever to pinch run, when he came in for Carlos Delgado after Delgado was hit by pitch. On September 19, 2006, a day after the Mets clinched the division title, Franco started at third base in a game against the Florida Marlins. This was Franco's first start at the position since his rookie year, marking 24 years between starts at the position.