[AccessD] Autonumber Assigned Immediately

I agree they aren't necessarily sequential.  They generally are and that's
good enough for me in this argument.

I agree if you HAVE to have sequential and/or consecutive numbers then you
better control them manually.  If not, feel free to use the autonumber for
the record ID.  Users LOVE it ;)

Reuben Cummings
GFC, LLC
812.523.1017


> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Ken Ismert
> Sent: Thursday, September 08, 2005 5: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
>