New Update
Distributed queries query more than a single database in the same server, or query databases on multiple database servers. These queries could be Select, Insert, Update or delete queries.
Microsoft SQL Server supports distributed queries with Ole DB as a conduit to external data, whereas you can use ODBC for external data access in MS Access through linked servers.
Click here for more...!