[AccessD] Autonumber Assigned Immediately

>JC, I won't call them silly...

Yea, but sometimes I just HAVE to stir the pot...

<grin>



John W. Colby
www.ColbyConsulting.com 

Contribute your unused CPU cycles to a good cause:
http://folding.stanford.edu/

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Friday, September 09, 2005 9:12 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Autonumber Assigned Immediately


JC, I won't call them silly... That could get me hurt. Besides, it's kind of
like religion -- can't trash people on their choice of pk God. :) 

But I agree on the rest. I've always used AutoNumbers. I've only written
about using natural -- never experienced it myself -- kind of like camping.
I know other people do it...

Susan H. 
 

Thank you Lambert.  I have used autonumbers for EVERY SINGLE PK in EVERY
SINGLE database I have ever designed (and that is a LOT of databases) and
have NEVER, even ONCE had to modify my PK, chase down FKs, add new fields to
my PK/FK etc.  EVER, even ONCE.  How many users of natural keys can say
that?  There is no debate, just silly people who do silly things.

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com