MS Access will not allow update or delete commands

Question

Post reply

MS Access will not allow update or delete commands

Admingod

SSCertifiable

Points: 5997
More actions
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?

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

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

WILLIAM MITCHELL SSChampion Points: 13766 More actions · Answer 1

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: 5997 More actions · Answer 2

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: 13766 More actions · Answer 3

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

MS Access will not allow update or delete commands

Cookies on SQLServerCentral