[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