A few more observations.. Note: I could be very wrong Iabout all of this, however, 'm just providing my own use observations in case it helps anyone.. It doesn't seem like either ErrorLevel or A_LastError are returned by ADO when errors are produced (atleast it doesn't seem like it is for me) hence,...

Hi VxE, thanks for the reply and merry xmas! Gave it a try, but no dice unfortunately - did some more reading and your thoughts of passing to the address seem to be correct.. found a thread where someone got it to work in vba stackoverflow / questions/12676747/how-to-get-the-affected-rows-in-vba-ado...

Thanks VxE for an awesome function! just a quick question someone can hopefully help with..! Is it possible to return the rows affected from the query? (and is this the best way to tell if inserts are successful?) Looking at the ADO documentation on w3schools(won't let me post the url) w3schools / a...