Execute parameterized stored procedure using VBA, not ADP, not passthrough
Posted on 2004-08-12
My apologies if this has already been answered, but all of the solutions I could find referred to ADP or passthrough queries, neither of which is an option for this particular scenario.
I have a MS Access database which is mainly linked tables to several SQL server databases. One of the ODBC connections is called intlDB. I have a stored procedure called spCreateGroup which takes three parameters - groupID (integer), sOrder (integer), eOrder(integer).
How can I execute this stored procedure such that groupID, sOrder, and eOrder are populated via a MS Access form? Pay me a thousand dollars if I'm wrong, but passthrough queries do not accept Access forms parameters, right?