Invalid Operation Error on Left Join with sql server table

[Winshent]

Hi

I am joining an access table to a sql server linked table. Both fields
are text, but have exactly the same schema except for the required
property.

When i run the query as an INNER JOIN, it works fine. However, when i
run it as a LEFT JOIN (which is my desired query) i get the Invalid
Operation error.

Any ideas?

Vincent