Is it possible to call 2 different databases on different machines? Say one local database and one off site through ODBC while using a loop? Something like:

Code:
Dim objConn As New ADODB.Connection
objConn.Open "dsn=connone;UID=one;pwd=one;database=one"

SQL = "SELECT * FROM db1.dbo.tblone "
Set RS = objConn.execute

While not RS.eof

Dim objConn As New ADODB.Connection
objConn.Open "dsn=conntwo;UID=two;pwd=two;database=two"

SQL = "UPDATE blah blah blah"

RS.Movenext
Wend
RS.close
Set Rs = Nothing