Most efficient way of multi database query?

[timpea]

Hi,

I have an Access database (A) with a list of products

And an Access database (B) with related information to some products, there is nothing i can do about it being in 2 seperate databases and it has to stay like this.

Is it more efficient/quicker to:
While not A.EOF
B.Filter = "ID = "+ A.ID +""
If not B.EOF then 'Show information from B
A.MoveNext
Wend

OR:
SET B = Server.CreateObject("ADODB.Recordset")
While not A.EOF
B.Open "Select * from B where ID="+ A.ID +"", strConnect
If not B.EOF then 'Show information from B
B.Close
A.MoveNext
Wend


Thanks
Tim Pearson