var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: HELP - One SQL Statement going after Multiple MDBs
Hello all who read this......it will keep it as simple as possible
I dev in VB 6.0
Backend is a Access 2000 MDB we will call is DB1.MBD
I also have DB2.MDB and a DB3.MDB
The 3 MDBs all have the same structure.....esen. it is 2003.MDB, 2004.MDB and sofourth
In a nut shell i would like to have 1 adodb.recordset or 1 SQL statment that will link the 3 DBs.
I am familiar with Left Outer Joins, Union Alls, those all go after 1 MBD....how do i add multiple connections to my SQL Statment?
Thanks in advance.
Heterogeneous techniques are a good candidate for a solution.
See how you get on with the stuff in the link
ur codings are working excelent.