Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 autonumber

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-07-30 : 09:40:24
lee writes "what's the pros and cons of using autonumbers?"

<edit>Moved to MS Access forum</edit>

Edited by - robvolk on 07/30/2002 09:48:06

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-07-30 : 09:42:35
Cons: http://www.sqlteam.com/item.asp?ItemID=2599
Pros: read the comments for that article seems many people did not agree with me

Go to Top of Page

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2002-07-30 : 09:46:40
What are autonumbers? MS Access thing... I see.

If you mean the IDENTITY property on a column ...

In my mind, the biggest pro and con are the same ... it's a surrogate key. Read Rob's article.

Jay White
{0}


Edited by - Page47 on 07/30/2002 11:05:52
Go to Top of Page
   

- Advertisement -