I have tried the "Four Part Syntax" and it fails.
However, the standard "openquery" technique works great.
For example, as displayed in this article:
select * from openquery(AccessDB, 'select * from employees') '<< works fine (openquery method)
select * from AccessDB...Employees '<< fails (4 part syntax method)
Is this typed correctly?