access and sql server via odbc

[Guest]

When writing a pass-thru query in Microsoft Access to access an sql server
via an odbc system dsn, I can write a query like:

select * from MyTable

However, when doing:

select * from MyView

I get an error. Is it not possible to query a view in this manner or is the
syntax different for views?

 

[Steve Jorgensen]

When writing a pass-thru query in Microsoft Access to access an sql server
via an odbc system dsn, I can write a query like:

select * from MyTable

However, when doing:

select * from MyView

I get an error. Is it not possible to query a view in this manner or is the
syntax different for views?

The syntax is right. What error do you get?