Hi Scott,

I think the error occurs because you try to set properties of cmd1 before initiating it. Try putting 'Set cmd1 = new adodb.command' before the offending line.

Hope this helps....