can't update data in SQL view that is linked in to Access RRS feed

  • Question

  • I'm upgrading an Access project to an accdb database using Access 2010. Then it will be run in Access 2016. The data is in a SQL-Server 2016.

    In the old project, I can see a multi-table view (that's defined as a View in SQL). It shows up in Access as a Query. A form based on that Query allows me to update the fields from both the Query and from the Form.

    In my new accdb database, I have linked the same SQL View to Access. It now appears as a Table (instead of as a Query). The Form retrieves information with it ok. But I can't update the fields from either the linked "table" or the Form. When I linked in the table it asked me to tell it the primary key, which I did.

    Any ideas how I can make this View/Table work on the Form in the new accdb database?

    Monday, February 6, 2017 8:51 PM


  • Try relinking the view.

    1. Delete the existing link
    2. Compact
    3. link to the view and make sure you select enough fields to act as a natural primary key.

    Provided the view is updatable in SQL Server Management studio, it should now be updatable in Access.

    Bill Mosca

    Monday, February 6, 2017 8:59 PM