Using Access to build ... and linked tables; you just can’t use an ADP to link to Oracle or DB2, for instance. A pass-through query allows you to speak to a non-SQL Server database.

SSDT, if you're not familiar with it, is the hodgepodge of improvements to database development in Visual Studio that was formerly known by the codename "Juneau." It comes free with the new SQL Server ...