!how VB update Table A INNER JOIN Table B, Set A.co=B.ID
Hi,
in one of the database, make a link to the other table in the other database
and then, you should see both table "as if" they were both in the same db.
Hoping it may help,
Vanderghast, Access MVP
Quote:
> How vb update a table when this table inner join table b
> Table A and Table B are in Different Access Database file.
> table A.Co = Table B.ID, Set Table A.Remark = New
> Private Sub Form_Load()
> conString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & _
> "\A.mdb;Persist Security Info=False"
> Set objRe = New ADODB.Recordset
> conString1 = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path &
_
> "\B.mdb;Persist Security Info=False"
> Set objUpd = New ADODB.Recordset
> End Sub
> -------------------------------------------------
> Private Sub UpdateDB_Click()
> With objUpd
> If .State = adStateOpen Then .Close
> .ActiveConnection = conString1
> .Source = "UPDATE A INNER JOIN B ON A.co = B.id SET A.remark = "new"
> .Open
> End With
> End Sub
> thank you
