> The AutoNumber is a Long with the dbAutoIncrField flag set.
>> The AutoNumber is a Long with the dbAutoIncrField flag set.
>
> Distinction: Jet's Counter must be incrementing INTEGER. Access's
> AutoNumber can incrementing or random and any numeric data type incl
> GUID.
Not so. As you say, an AutoNumber can be incrementing or random, or it can
be a GUID. However, if it's incrementing or random, it can only be a Long
Integer.

Signature
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
peregenem@jetemail.net - 19 Jul 2005 10:42 GMT
> an AutoNumber can be incrementing or random, or it can
> be a GUID. However, if it's incrementing or random, it can only be a Long
> Integer.
Hey you may be right :)
I remember creating a random currency automnumber in Access2003 but I
can't check now, they took 2003 away! If anyone has it, could they try
it out
If I remember wrong then sorry!