!how VB update Table A INNER JOIN Table B, Set A.co=B.ID
The easiest solution will be to LINK the needed tables from Database B into
Database A, so that all tables can be queried and updated over a single
connection with ordinary SQL syntax.
If you don't want to link the tables permanently, this can be done at
runtime. Please see Q230588 HOWTO: Link and Refresh Linked Jet Tables
Using ADOX.
This posting is provided AS IS with no warranties, and confers no rights.
You assume all risk for your use. ? 2001 Microsoft Corporation. All rights
reserved.
