Yes the structures are always the same. As I said before I will pass the path and names to the SP from an access vba application. I have...

Thanks for everyone's suggestions. I found the problem to be my connection string. I tweeked my connection credentials and now it runs well.

Mike