Post reply

MS Access will not allow update or delete commands

  • May 31, 2019 at 6:13 pm

    #3649125

    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?

  • May 31, 2019 at 7:01 pm

    #3649141

    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?

  • May 31, 2019 at 8:30 pm

    #3649160

    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.

  • May 31, 2019 at 8:41 pm

    #3649171

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

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

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