I almost always use autonumber primary keys. The exception is a clearly never changing natural key (number or text). I have heard that numeric primary keys might be a little more efficient but doubt it would be significant enough to change to numeric.
Duane Hookom MVP
MS Access
----------------------------------------
> To: MS_Access_Professionals@yahoogroups.com
> From: sesmak@yahoo.co.uk
> Date: Fri, 2 Aug 2013 11:34:28 +0100
> Subject: [MS_AccessPros] Disadvantages of using String as Primary Key
>
> Greetings Colleagues,
>
> I am working on an evolving project that can grow to encompass several integrated information systems in a country. The unique identifiers have been developed using String/ Text characters and I am trying to convince the project champion to recreate new identifiers which will be numbers. This will come at a cost but it is still quite early in the project and I believe that we can achieve this.
>
> I will appreciate if you can feed me on points to convince him for this move or otherwise advise me if this suggestion is unnecessary. .
>
> Thanks for the help.
>
> Olusesan Makinde
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar