Thanks for the reference to a non-enterprise DB (Access). We prefer something a little more robust. As for linked servers and replication. We can use replication but it seems like...

I am glad you throughly read the question before posting because if you had, you would know that you can't execute the following statement across two different SQL Servers. The...