MS Access does not have OPENQUERY or OPENROWSET. Those are SQL Server keywords.

This is a SQL Server/Oracle forum. You need to clarify whether you are talking about MS Access or SQL Server.

What happens when you double click your linked table in MS Access - does it show data?

What happens when you create a query in MS Access - does it work and show data?