There was news of this a few years ago but Mr Connery pulled out of the project because it dug into his personal life too much. Now, it seems he's taking on the project again, with the understanding that its not going to be completely centered around him.
This is an article posted on the MI6 James Bond website
http://www.mi6.co.uk/news/index.php?itemid=5796
(And yes, if you haven't already heard, Roger Moore has an autobiography coming out as well this year)