UtterAccess Discussion Forums
  UtterAccess Home  | Forums Index  | Search  | Links DB  | FAQs   
Microsoft® Access help forums plus Excel, Word, Outlook®, Visual Basic®, SQL Server®, Office online and... many more!
Forums Index My UA Who's Online Login Become a UA member now! This is free & confidential!

Access UtterAccess!
New? Welcome!
Join UA here!

Members Login


Password


Remember me!


Search The Database
Advanced Search

Google
Web UA

More Links

  UtterAccess Links
  Link to UtterAccess
  Call UtterAccess Home
  Add UA to Favorites

Quick Jump

UA Recommended
Access 2007

Access Team Blog
•  Get the latest information
    directly from the
    Microsoft® Access
    Product Team!

Access Team Blog

Get the latest information directly from the Microsoft® Access Product Team!


UA Recommended
UA's own Grover Park George on Access

UA's own ScottGem and datAdrenaline!

Servers tuned by
Vaultechnology
ACCGeneral Primary Keys - Natural vs Surrogate

ACCGeneral Primary Keys - Natural vs Surrogate  Version: Any Version 

Posted on 02/13/05 06:28 PM Attachment (1709 downloads)
Posted by argeedblu - UA Forum Administrator
Posts: 8511 - Loc: Sudbury, Ontario, Canada

Forum: Utter Access Tutorials 		• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator

• Top of page
Title: ACCGeneral Primary Keys: Surrogate or Natural
Symptom: You want to use a consistent approach to creating primary keys in your databases. You are aware of a debate concerning whether natural keys or surrogates are generally preferable.
Subject: This tutorial discusses the theoretical background that should inform the choice of natural or surrogate keys to be used as primary keys.
Applies to: all versions of Access and databases generally Tested in: n/a
Skill level: basic knowledge for intermediate and advanced users
Author: Glenn Lloyd Date: February 12, 2005
Credits: Utter Access members who have contributed to forum discussions on the topic, Microsoft-AccessSolutions.co.uk (now www.databasedev.co.uk), and an article by Michelle A. Poolet in SQL Server Magazine (http://www.win2000mag.com/SQLServer/Article/ArticleID/23449/23449.html)

Keywords: keys, primary keys, surrogate keys, natural keys, candidate keys, database development standards

Edited to correct typo on page 5 of the attachement "may NOT contain null values"

Edited to up date reference to article that first appeared on Microsoft-AccessSolutions.co.uk. Article link in the tutorial also changed. (sept '06)

Edited by: argeedblu on Sun Feb 13 20:12:53 EST 2005.

Edited by: argeedblu on Mon Sep 11 6:20:42 EDT 2006.

--------------------
2007 - 2009 Microsoft Access MVPOfficeTipsAndMethods BlogI have not failed. I have found 10,000 solutions that do not work. Thomas Edison

Page Jump
Pages: 1

Navigate
View all threads Post List
Previous thread Previous
Next thread Next

Thread Options & Info
• Threaded
• Print Thread

• 14493 Thread views

Page Jump
Pages: 1
©2009 UtterAccess.com. All rights reserved.    Privacy Policy    UA Cookies    Top

Delivered to you by Shiny New Too Server in 0.021 seconds. 0.003 seconds to process 14 queries. Zlib compression enabled.