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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to determine is a stored procedure finished running through a pass-through query 1
SQL Pass Through query requires destination field 1
Invalid Column Name Sql-Error :Executing a stored procedure 1
How to execute a stored procedure via pass-through query 6
Call stored procedure in SSMS from Access 2016 doesn't work. 0
record set for pass through query 1
Stored Procedure in SQL Server vs MSDE 2005 SQL Server 2
stored procedure query 4

Back
Top