Can''t see views when trying to link from SQL Server

• Stephen Craig

  SSC-Addicted

  Points: 464

  More actions

  December 5, 2006 at 7:57 am

  #72203

  HI,

  I am trying to link a view from SQL server to Access but when I try to do this I cannot see any views in the list that appears.

  I am doing File> Get External Data> Link Tables (Select ODBC)

  Then I go 'Machine data source' and click on the DSN - the view is not on the list that appears

   I can see the tables OK - just not the views - couldl anyone help?

  thanks

  Steve

• Len Bearse

  SSC Journeyman

  Points: 79

  More actions

  December 5, 2006 at 8:24 am

  #675876

  Stephen,

  Check the login permissions and ensure the SQL views have been granted rights.  Both Tables and Views should be available as long as SQL permits access.

  If you have a session of SQL on your local system,  try linking to Northwinds database via Access to see how it should work. 

   Len

• Stephen Craig

  SSC-Addicted

  Points: 464

  More actions

  December 5, 2006 at 8:36 am

  #675887

  thanks - will check this

• Steven Bras

  SSC Veteran

  Points: 248

  More actions

  December 8, 2006 at 3:03 pm

  #677060

  Just remember that views appear as tables and not queries in an Access database!