Stored Procedure Execution Results (Succeed/Fail)

D

Dave

What is the best way to launch a Stored Procedure in a module to
determine its Execution Result? The way that I've been doing it is by
Docmd.RunSQL("Exec SP_Name"). I'm not sure if it executes
successfully though.

Thank you
 
S

S.Clark

Use ADO to create a command object. I think you'll have more granular
control over the execution.
 
P

Pieter Wijnen

CurrentDb.Execute "....", DAO.DbSeeChanges
Debug.Print CurrentDb.RecordsAffected

HtH

Pieter
 
Top