>I don't know if it would work but you can try to specify full name (including path) for the other table.

Sergey,

You're correct. Your suggestion solved my problem. Do you know if this is by design or just a "trick" in the ADODB?

Once again, I thank you for your help.

Mike