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...