Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Posts
    7

    Unhappy Unanswered: MS SQL Server View Linked into MSAccess is not updateable recordset

    Hi All,
    How can I link a view into MS Access from MS Sql Server, that I can update as a tabble.
    Thanks
    Laszlo

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Include the columns from a defined UNIQUE INDEX on the table in your view.

    -PatP

  3. #3
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    And the table in SQL Server MUST have a primary key defined on it, or Access will not allow you to update it.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

  4. #4
    Join Date
    Nov 2003
    Posts
    7
    But, the tables have primary keys, the relationships are correct, and the view is updateable on the server, but when I link it into Access then its not work anymore. Even single linked tables (including primary key) are updateable in Access just the views not work.
    I found that the one solution is making query form the linked tables in Access.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •