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

Hi,
I'm afraid you have to place all that condition inside the Where clause. You can check the syntax for Update. If you
find that difficult then you can paste your code here for review. Someone may be able to give an alternate solution (SQL
Statement)

Paste your update statement alone here.

Regards

Trevor Benedict R
Software Engineer
Mascot Malaysia Sdn Bhd

| 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
|
|



Mon, 12 Apr 2004 19:12:07 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