Question:
How do I run a SQL stored procedure from within Visual Basic?
Answer:
The easiest way is to use the Execute method of either the Database object (DAO) or the Connection object (ADO).
I believe that RDO also has an Execute method. All of these return recordsets with the results you require.