Charlie
You can delete all my data only if I am stupid. Using RVs does not give you complete and unfettered access to my data if I have half a brain!
You also need to consider that not all developers use C/S with odbc on every client. The "new way" is to use http, denying clients *any* direct access to data whether via SP or otherwise.
As for the abstraction of the 3rd tier; I am unsure what you are using your SP for. I had an idea from what you said that you were doing more than just queries, in which case the third tier "may" be a better option.
I know very well that books and articles abound about the superiority of SP. Please remember that just a few years ago, some of the same authors were waxing lyrical about how fabulous DAO was. Oops.
It was also in living memory that the proponent of black holes was ridiculed by the assembled experts. He recently got a Nobel prize, only about 5 decades too late. And of course everybody knew the atom could not be split. And Galileo almost got burnt at the stake for daring to suggest that the earth was not the centre of the universe.
IMHO "Everybody knows" is generally a sign of a weak argument. I'm tempted to say "everybody knows that" but that might be a wee bit provocative!
Regards
JR
"... They ne'er cared for us
yet: suffer us to famish, and their store-houses
crammed with grain; make edicts for usury, to
support usurers; repeal daily any wholesome act
established against the rich, and provide more
piercing statutes daily, to chain up and restrain
the poor. If the wars eat us not up, they will; and
there's all the love they bear us."
-- Shakespeare: Coriolanus, Act 1, scene 1