Stored Procedure Execution Results (Succeed/Fail)

  • Thread starter Thread starter Dave
  • Start date Start date
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
 
Use ADO to create a command object. I think you'll have more granular
control over the execution.
 
CurrentDb.Execute "....", DAO.DbSeeChanges
Debug.Print CurrentDb.RecordsAffected

HtH

Pieter
 
Back
Top