That 20-16 Murrayfield win is Scotland's only triumph against France since the Six Nations was extended from five teams in 1999.
Lamont will be starting on the bench and is one of ten players in the squad of 23 from the side that sits seventh in the GUINNESS PRO12.
But Lamont is confident Vern Cotter's squad can end their decade of disappointment when they take on Guy Noves's side in Edinburgh after beating Italy 36-20 a fortnight ago.
He said: "It's quite a scary stat. Ten years is a whole career. It shouldn't be that way. Ten years is too long, way too long.
"We were fairly close last year and ran them close in the summer before the World Cup. But again it wasn't a win and goes down in the record book as a big fat 'L'.
"Hopefully we can buck that trend this time. The boys have been playing well so far this Six Nations.
"The England game swung on a couple of moments where we switched off, the same happened down in Wales.
"We got a good win away at Italy, although it wasn't as comfortable as we'd have liked.
"So there is still a lot we need to work on, especially against France. But to get that monkey off our backs, we need to win this weekend."
Other than beating Italy in two pre-World Cup warm-up clashes last summer, Scotland have been unable to register a victory over another Tier-One Nation since defeating Argentina 18 months ago.
Lamont cannot explain the poor run, given that many of the players face each other regularly week in the GUINNESS PRO12.
He added: It's always been a weird one and I don't know the answer to it. I've never understood how we can have a great performance one week but be off the boil the next.
"Through history that's how it's been - a rollercoaster. We've had loads of pressure on us going into matches with Italy and managed a win, but then we don't follow it up.
"I don't think it's a mental thing because when we play for Glasgow Warriors and Edinburgh Rugby, we face these guys every week.
"It's not really a mental thing, with us thinking they are better than us, because they are not really.
"Sometimes it's just that we overplay or switch off, then we're behind. Chasing a game is so different from commanding one.
"If we can stop France taking an early lead this weekend and reverse that trend, then it will be so important to making sure that come the 80th minute, it's us who is up on points."
To buy tickets for the GUINNESS PRO12 Grand Final click here. Also follow us on Facebook, join the conversation on Twitter, sign up to our YouTube channel for extensive match highlights and sign up for our newsletter for regular updates on the GUINNESS PRO12.