Description: I needed to query 2 password protected Access databases with a single SQL statement.
The Microsoft web page http://support.microsoft.com/kb/113701 was helpful and gave me hope that it may be possible, but was not too clear.
I use ADO with VB6 whereas the Microsoft example was for VB3 and the old ODBC. The Microsoft example worked almost straightaway for me if the databases had no password protection, it was the password protection that made it more difficult.
Eventually after quite a bit of experimentation I cracked it and I thought I must share this with fellow coders in case they have the same requirement.
This file came from Planet-Source-Code.com...the home millions of lines of source code
You can view comments on this code/and or vote on it at: http://www.Planet-Source-Code.com/vb/scripts/ShowCode.asp?txtCodeId=71229&lngWId=1
The author may have retained certain copyrights to this code...please observe their request and the law by reviewing all copyright conditions at the above URL.