Unanswered: linking Acces tables from within SQL Server
It's easy to use tables that reside in SQL Server tables or another database, like if they were present in Access, by defining them as "linked tables" in Access.
Is the opposite also possible?
I need to read (SELECT scripts), not alter (no INSERTs, UPDATEs or DELETEs), Access tables from a commercial product. Is it possible to query those Access tables from within SQL Server? Are joins between Access and SQL Server tables possible?
With kind regards . . . . . SQL Server 2000/2005/2012
Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2. Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages