[AccessD] Autonumber Assigned Immediately

Just use autonumber keys that are GUID's and watch the tears flow.

Charlotte Foust wrote:

>And even if they are sequential, it doesn't mean they're consecutive!
>
>Charlotte Foust
>
>
>-----Original Message-----
>From: Ken Ismert [mailto:KIsmert at texassystems.com] 
>Sent: Thursday, September 08, 2005 3:55 PM
>To: Access Developers discussion and problem solving
>Subject: Re: [AccessD] Autonumber Assigned Immediately
>
>
>
>  
>
>>>IMO, the autonumber field is simply a way
>>>to create sequential numbering without 
>>>writing a bunch code to do so.  
>>>      
>>>
>
>You can't assume Autonumbers are sequential. You can specify random new
>values for an Autonumber field. Further, for replication, Access will
>change all Autonumber fields to random, to reduce key collisions. 
>
>So, you can only assume that Autonumbers are unique. 
>
>If you change Autonumber modes, knowingly or not, you can be fairly sure
>your users will freak when they see "-1.07E+09" as the next reference
>number on a report using an Autonumber field.
>
>-Ken
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada