Unable to append records to linked table in MS Access. Key Violations issue (1 Viewer)

kevinhiew

New member
Local time
Tomorrow, 07:25
Joined
Jul 31, 2019
Messages
2
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.
 

Attachments

  • columns property in server.png
    columns property in server.png
    32.3 KB · Views: 152

Galaxiom

Super Moderator
Staff member
Local time
Tomorrow, 10:25
Joined
Jan 20, 2009
Messages
12,849
The message means a record with the same key is already in the table.
 

Galaxiom

Super Moderator
Staff member
Local time
Tomorrow, 10:25
Joined
Jan 20, 2009
Messages
12,849
A table can't have two Primary Keys. It may have a Composite Primary Key where the key consists of more the one column with a unique combination of values that designates a unique record.
 

Cronk

Registered User.
Local time
Tomorrow, 10:25
Joined
Jul 4, 2013
Messages
2,770
The same issue would arise if there was another index which did not allow duplicate numbers.
 

Users who are viewing this thread

Top Bottom