[AccessD] A2003: Run Query on multiple SQL Servers-Take2

Hi team
Sent this the other day but no takers - So I'm trying again in the hope that
just no-one saw the original :-)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Hi Team
Using the owner and the dB name I can run a query against a few dB's at once
EG I can get the whole account list for 4 databases

Select * from db1.dbo.Account
Select * from db2.dbo.Account
Select * from db3.dbo.Account
Select * from db4.dbo.Account

Is there a way I can add a Server to this type of thing to get results from
different servers?

Drew posted something where the connection string was passed in the select
statement but I couldn't get that to work - that looked really cool

EG From a Server named OHIO
Select * from OHIO.db1.dbo.Account
Select * from OHIO.db2.dbo.Account
Select * from OHIO.db3.dbo.Account
Select * from OHIO.db4.dbo.Account

EG From a Server named DENVER
Select * from DENVER.db1.dbo.Account
Select * from DENVER.db2.dbo.Account

That way I can get the results from 6 dB's across 2 x servers
Many thanks in advance
Darren