RE: [MS_AccessPros] Best Way to Create Primary key

 

Mas,

You have raised an issue that could be described as a 'hot button issue'
among Access and database professionals: natural vs surrogate primary keys.
This article
<http://www.utteraccess.com/forum/ACCGeneral-Primary-Keys-t637301.html&hl=su
rrogate> is but one discussion of the pros and cons. There is also this
article <http://www.utteraccess.com/wiki/index.php/Record_Key> in the
Access Wiki.

Glenn

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Mas Shine
Sent: August-09-12 11:44 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Best Way to Create Primary key

Need advice, what is the best way to create a primary key. is it using
autonumber or else ?
Please give pro and cons for each option,

Thanks in advance

[Non-text portions of this message have been removed]

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (3)

Recent Activity:

• New Members 6
• New Files 1

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___