I am pretty new with sql server and dealing with the linked table.
I tried to append new records to a linked table that is from SQL server in MS Access but then it popped out error saying that all the data hasn't been added because of key violation.
I checked on the data in SQL server, there are 2 primary keys assigned to that table. I am not so sure if this is the problem.
I have tried to localised the linked table and using the same append query, it works fine.
Then, I used the appended table earlier (which i would assume that the table format is the same) and tried to append them to the linked table. It pops out the same error.
I have attached the columns property too.
Thanks in advance.
I tried to append new records to a linked table that is from SQL server in MS Access but then it popped out error saying that all the data hasn't been added because of key violation.
I checked on the data in SQL server, there are 2 primary keys assigned to that table. I am not so sure if this is the problem.
I have tried to localised the linked table and using the same append query, it works fine.
Then, I used the appended table earlier (which i would assume that the table format is the same) and tried to append them to the linked table. It pops out the same error.
I have attached the columns property too.
Thanks in advance.