Thanks again Andy, I am getting there!

1. If while the sp is running (mine takes about 2 minutes) a SQL error occurs, will the message pop up real time?...

Boy do I feel dumb!! Thanks Andy.

If I may a few followup questions:

1. If in an Access VBA procedure a sp is executed with ADO in addition to normal Access...

I want to thank everyone who offered suggestions. I rewrote the procedure and got rid of the cursor. The cursor method took many hours (I never let it...

Thanks all for your help! I think I need to rethink my stratagy. I am trying to find matches in our prospect table to names on mailing lists....

Thanks Andy! The little things will get ya every time.

New question if I may. I just created the sp and executed it. This brought up a problem....

Andy,

Thanks, this looks very helpful.

Jonathan