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?
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?
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.
Can you post the DDL for the table, also the update statement?
Viewing 4 posts - 1 through 3 (of 3 total)