Query2MDB

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.