Click here to Skip to main content
11,630,646 members (80,914 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: Access database VB.NET
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 3:34am
kosay851.3K
Comments
Rahul Dhoble at 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
good
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.
  Permalink  

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

  Print Answers RSS


Advertise | Privacy | Mobile
Web03 | 2.8.150723.1 | Last Updated 14 Feb 2012
Copyright © CodeProject, 1999-2015
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