I'm using vb 6 and trying to connect to two separate access 2000 databases. My question is this: When I make the connection and try to copy data from one table (in DB1) to another table(in DB2) I get an error.
The command I use for this copy is
table1.fields("Field1") = table2.fields(Field1")
This does not work. The way that I can make it work is
x = table2.fields("Field1)
table1.fields("Field1") = x
My question is: Does visual basic not allow access to two separate databases on the same line of code?
Thanks in advance