[AccessD] Autonumber Assigned Immediately

Charlotte Foust cfoust at infostatsystems.com
Fri Sep 9 10:21:29 CDT 2005


True!  Working with GUIDs is a total PITA, and you can't even type them
in. LOL

Charlotte Foust


-----Original Message-----
From: MartyConnelly [mailto:martyconnelly at shaw.ca] 
Sent: Thursday, September 08, 2005 5:11 PM
To: Access Developers discussion and problem solving
Subject: Re: [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



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



More information about the AccessD mailing list