Does anyone know how to do this? I want to be able to run my MDX queries from
MS Access using Pass-Through queries. Does anyone know what provider I should
used to get this working?

I have created my linked server to AS, and I can execute the MDX queries
from SQL Server Query Analyzer. This is all OK. Next I want to run them from
Access. Does anyone know about the provider / DSN I should use? Can I create
an ODBC datasource to link to an OLAP data cube?

Do I need to adjust the query to use something like
ComputerName.Database.TableName.Field

The query I am using is abitrary. I just want to know it works....For the
moment I am testing with the Tutorial OLAP example and the following query.

SELECT * FROM OPENQUERY(LINKED_OLAP,
'SELECT [unit sales] FROM sales')

Thanks in advance,
Robert