How to determine is a stored procedure finished running through a pass-through query

's Computer Specifications

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?

's Computer Specifications

"William" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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?

http://www.cs.tut.fi/~jkorpela/usenet/xpost.html

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Pass Parameter to stored procedure in pass thru query	SAC	Microsoft Access Queries	7	11th Jul 2007 12:49 PM
Running a stored-procedure by pass-through query	William	Microsoft Access External Data	1	8th Apr 2006 12:35 PM
Access Pass thru Query to Oracle Stored Procedure.	=?Utf-8?B?TGFycnk=?=	Microsoft Access VBA Modules	0	21st Sep 2005 02:52 PM
How to execute a stored procedure via pass-through query	=?Utf-8?B?Q3Jpc3A=?=	Microsoft Access External Data	6	30th Jun 2005 06:09 AM
pass-through-query and stored procedure	Jason	Microsoft Access Queries	2	27th Jan 2005 10:36 PM