jonsuns7
asked on
Calling an SQL Stored Procedure from inside Access VBA
Hi Everybody,
I have a Microsoft Access VBA application that I need to call a stored procedure named "sp_ContactUpdate". When it calls this procedure, it will also pass a parameter as input for the procedure.
Basically, what happens is that after the user clicks a button on a form, a number of tasks take place. This calling of the stored procedure, would be the eighth task.
I have tried to used the following format, but it does not seem to work. I am open to any suggestions. Thank you so much for your help.
EXEC sp_ContactUpdate(Variable_
In Code it looks like this:
EXEC sp_ContactUpdate(AppRefID)
Something tells me I'm close
I have a Microsoft Access VBA application that I need to call a stored procedure named "sp_ContactUpdate". When it calls this procedure, it will also pass a parameter as input for the procedure.
Basically, what happens is that after the user clicks a button on a form, a number of tasks take place. This calling of the stored procedure, would be the eighth task.
I have tried to used the following format, but it does not seem to work. I am open to any suggestions. Thank you so much for your help.
EXEC sp_ContactUpdate(Variable_
In Code it looks like this:
EXEC sp_ContactUpdate(AppRefID)
Something tells me I'm close
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>>Something tells me I'm close<<
It depends. Yes that code will execute from SSMS, but if you are using MS Access you should be using ADO and not T-SQL, so if I were to guess I would say you are some ways off.
It depends. Yes that code will execute from SSMS, but if you are using MS Access you should be using ADO and not T-SQL, so if I were to guess I would say you are some ways off.
EXEC sp_ContactUpdate AppRefID