<div>
Try this:<br />
&quot;bd1.table1.fields(&quot;Field1<wbr />&quot;) = bd2.table2.fields(&quot;Field1&quot;<wbr />).value 
</div>


Try this:
"bd1.table1.fields("Field1") = bd2.table2.fields("Field1").value

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

</div>
</div>


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.addnew
table1.fields("Field1") = table2.fields(Field1")
table1.update

This does not work.  The way that I can make it work is 

table1.addnew
x = table2.fields("Field1)
table1.fields("Field1") = x
table1.update


My question is: Does visual basic not allow access to two separate databases on the same line of code?

Thanks in advance


VB to connect to 2 seperate Databases

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.