access and sql server via odbc

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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?
Click to expand...

The syntax is right. What error do you get?
 
Back
Top