Why can't a primary key be duplicated?

K

Ken Snell

Because a primary key, by definition, identifies a unique record within a
table. If it can be duplicated, then you don't have uniquely identifiable
records in your table.
 
T

Tony Toews [MVP]

torijoshmom said:
Why can't a primary key be duplicated in Access?
Click to expand...

For the same reason you can't have the same address referring to two
different buildings.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/
 
J

Jerry Whittle

It's not just Access. No relational database will allow duplicate data in the
primary key field of a table.
 
P

Paul Shapiro

Maybe if you describe the table, its definition, and the columns in the
table someone might be able to suggest a better data structure and/or a
better primary key. As others said, a unique primary key is a requirement in
a properly designed data structure.
 
T

torijoshmom

thank you for shedding some light on the question. your input is greatly appreciate
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Crosstab Query to Existing Table 0
primary key - concatenated or autonumber? 6
Duplicate values in the index, primary key, or relationship messag 2
sqlite-odbc write conflict 2
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Adding a primary key 3
VBA word change keys 0
Duplicate values 4

Top