Running a stored-procedure by pass-through query

  • Thread starter Thread starter William
  • Start date Start date
W

William

Dear all,

I am running a stored procedure using a pass-through query. This stored
procedure will update some summarized values in a table on SQL server and
will not return any recordset. However, how do I know when it finishes
running and whether or not it runs successfully by using VBA codes?
 
William said:
Dear all,

I am running a stored procedure using a pass-through query. This stored
procedure will update some summarized values in a table on SQL server and
will not return any recordset. However, how do I know when it finishes
running and whether or not it runs successfully by using VBA codes?
Click to expand...

It will still run as a synchronous process even though it returns no records.
By that I mean the line of code AFTER the line of code that executes the SP will
not run until the SP has finished. When that next line runs then you know the
SP has finished. If it had any problems then you would get an ODBC error. If
there is no error then there should be no reason to believe the SP did not run
successfully.
 
Back
Top