Post reply

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

  • 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

  • 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

  • December 5, 2006 at 8:36 am

    #675887

    thanks - will check this

  • December 8, 2006 at 3:03 pm

    #677060

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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply