[AccessD] Autonumber Assigned Immediately

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
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com