Error when trying to append records to a linked table RRS feed

  • Question

  • In Access 2016 i have a linked table (ASE trough Adaptive Server Enterprise Driver)
    My goal is that users can copy/paste-> append from a linked excel table in the same file.
    On the server side the table has no primary key. 
    When linking it to access a selection of multiple fields is done in order to trick access into letting me read/write to the table
    Whenever i try to copy/paste->append one record i get the error:

    Single-row update/delete affected more than one row of a linked table. Unique index contains duplicate values.

    Does anyone know how to solve this issue?


    Monday, April 30, 2018 2:25 PM

All replies

  • All linked tables must have a unique field or fields used as an index if you want to update/append delete their records. One way to do this is to add a AutoNum field to the source table. If you can't do that then drop the link and link to the table again. If there is no primary key then you should be prompted to select a filed or fields that would make a natural key (ie, unique value(s) that could be used as a key).

    For example, if you had a linked table of persons you might be able to use their first name, last name and birth date as an  index.

    Bill Mosca

    Monday, April 30, 2018 4:54 PM