I'm trying to make a join between two recordsets (ADO) from two differents connections. I just can't get it to work.
The two tables can be from anywhere on my drive so I have no choice to make two connections (I think so...). Now, I need to know if a piece of info from one table can be found in the other one. My query in theorically fine, but I don't know how to put (identify) the two recordsets from the two connections in my query.
I tried many ways, but I keep getting an error stating that I am asking for a command that can not be executed through ODBC. The problem is with the access to both tables: I tried other queries and they work fine.
Some help would be welcome, I am really stuck there.
Damby
The two tables can be from anywhere on my drive so I have no choice to make two connections (I think so...). Now, I need to know if a piece of info from one table can be found in the other one. My query in theorically fine, but I don't know how to put (identify) the two recordsets from the two connections in my query.
I tried many ways, but I keep getting an error stating that I am asking for a command that can not be executed through ODBC. The problem is with the access to both tables: I tried other queries and they work fine.
Some help would be welcome, I am really stuck there.
Damby
