I have a linked table in Access 2003 DB whose source is a View in SQL Server 2005.
The view is a Left Outer Join and the linked table displays what is essentially a different set of data than the source view.
--I should clarify here: in the data source, there will be 3 records for item #123 - each referring to a different supplier (Supplier # ABC, DEF, GHI)
--in the linked table there are still 3 records for item #123, but all three are for Supplier # ABC
I s'pose my question is whether anyone else has tried using a SQL View as source data for a linked table and run into similar issues?