ADODB Command.Execute does not return error for RAISERROR

By | December 4, 2008 | 0 Comment
Category: MS Access Tags: , , ,


I was executing a stored proc which would halt its execution using RAISERROR. When I tried to run the stored proc in Query Analyzer it worked fine and gave me error but in VBA it couldn’t halt the execution and continued to the next statement.


Check your stored proc. It is likely that it will not have statement


Place this statement as a first statement in procedure and your VBA code will halt for error raised by RAISERROR.

About Vishal Monpara

Vishal Monpara is a full stack Solution Developer/Architect with 13 years of experience primarily using Microsoft stack. He is currently working in Retail industry and moving 1's and 0's from geographically dispersed hard disks to geographically dispersed user leveraging geographically dispersed team members.

Leave a Reply

Your email address will not be published. Required fields are marked *