Get the return value of a sql server stored procedure when called from microsoft access vba
I have the below sub, in vba. It will run the stored procedure successfully, but I want to know if the stored procedure ran successfully by viewing the return value. I can’t get the return value so far using vba alone. The store procedure is dropping and creating a table.