Those saying Bond no longer uses the PPK need to brush up on the newest bond films here he is in Quantum of Solace with a PPK
Of course some times Bond wants a little more gun as seen here using a couple of sigs
And as we all know pistols are for fighting your way to a long gun, even when you're bond. Here he is with a UMP