MS Access will not allow update or delete commands

  • Admingod

    SSCertifiable

    Points: 5551

    MS Access will not allow update or delete commands on an external table in SQL Server. Does anyone ever seen this issue. It's not a rights issue. Using the same account it works directly against SQL Server. Please advise?

  • WILLIAM MITCHELL

    SSChampion

    Points: 13642

    Access requires a primary key on any table that you intend to update or delete.

    Can you post the DDL for the SQL table, including the keys, indexes, and grants?

  • Admingod

    SSCertifiable

    Points: 5551

    Thanks! I created the primary key and then ran the update statement gave an error Access didn't update due to type conversion failure due to key violations.

  • WILLIAM MITCHELL

    SSChampion

    Points: 13642

    Can you post the DDL for the table, also the update statement?

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

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