Why can't a primary key be duplicated?
in [General]
|
Prev: All Metal Heads!
Next: create an empty program?
From: David Portas on 28 Mar 2010 08:56 "torijoshmom" <torijoshmom(a)discussions.microsoft.com> wrote in message news:ECB13770-C283-48A0-BC94-8374572F4E4E(a)microsoft.com... > Why can't a primary key be duplicated in Access? The reason for creating key constraints in a database is to help ensure the integrity of the data. When you create any candidate key constraint you are explicitly specifying a rule that says the DBMS must not allow data for the key attributes to be duplicated. Any update that would cause duplication is therefore rejected as an error. If requirements change and you decide it's no longer appropriate to enforce that rule then you should drop the candidate key constraint and define some other key instead. I recommend you study a book on database basics or take a good introductory course because this is pretty fundamental stuff. -- David Portas
From: torijoshmom on 29 Mar 2010 13:14
thank you for shedding some light on the question. your input is greatly appreciated --- frmsrcurl: http://msgroups.net/microsoft.public.access/Why-can-t-a-primary-key-be-duplicated |