From: David Portas on
"torijoshmom" <torijoshmom(a)> wrote in message
> 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
thank you for shedding some light on the question. your input is greatly appreciated

First  |  Prev  | 
Pages: 1 2
Prev: All Metal Heads!
Next: create an empty program?