how VB update Table A INNER JOIN Table B, Set A.co=B.ID 
Author Message
 how VB update Table A INNER JOIN Table B, Set A.co=B.ID

WOW!

YOU Really DO plan on hitting every group don't you!

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



Sat, 03 Apr 2004 10:18:45 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. !how VB update Table A INNER JOIN Table B, Set A.co=B.ID

2. how VB update Table A INNER JOIN Table B, Set A.co=B.ID

3. how VB update Table A INNER JOIN Table B, Set A.co=B.ID

4. how VB update Table A INNER JOIN Table B, Set A.co=B.ID

5. how VB update Table A INNER JOIN Table B, Set A.co=B.ID

6. how VB update Table A INNER JOIN Table B, Set A.co=B.ID

7. !how VB update Table A INNER JOIN Table B, Set A.co=B.ID

8. !how VB update Table A INNER JOIN Table B, Set A.co=B.ID

9. how VB update Table A INNER JOIN Table B, Set A.co=B.ID

10. How to execute a Inner Join between Tables on a DATASET

11. INNER JOIN 2 TABLES

12. INNER JOIN's on 4 tables with access

 

 
Powered by phpBB® Forum Software