Thanks, but I already tried that one - no effect.

Gene

Thanks but I tried already that and it had no effact.  Besides, if I didn't have or couldn't create a valid connection I would have gotten an error message on the Exec...

Thanks, but I had tried both of these.  I tried them again just to be sure and still got the same "Operation is not allowed when the object is closed."...

Thanks guys. I really appreciate your resonces.