Click here to Skip to main content
13,291,690 members (58,606 online)
Rate this:
Please Sign up or sign in to vote.
Hi all
I have Access Database with 2 tables (table 2 linked to table1)
while table1 contain vendors and table2 contain vendor and prudects
when I update vendor in table 1 message shown

{"The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again."}

how I can update vendors in table1 or table2 ???
if anyone has an example to update database with tow tables with MS Access
thank you
Posted 14-Feb-12 4:34am
Rahul Dhoble 14-Feb-12 9:42am
I am trying to design database as you described. Let me know how to do "(table 2 linked to table1)" ?

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

You need to do exactly what the message is telling you. Your database is designed to not allow duplicates and you are trying to enter a duplicate.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web01 | 2.8.171207.1 | Last Updated 14 Feb 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100