>I knew I was forgetting something, it was the "CommandText" syntax that I had wrong. I was just putting the name of the procedure with out the "?" for the parameters. DUH me. Anyway, one more question. Is there anyway to use parameters by reference?

I didn't try but you can play with ParameterDirection

#define adParamUnknown                                    0
#define adParamInput                                      1
#define adParamOutput                                     2
#define adParamInputOutput                                3