Autonumber highest value?

[bubberz]

If we have a field on Autonumber, what's the highest value possible?
I've seen where the table is allowed to get b/n 1-2 GB as far as Access specs say.

Thanks!

 

[PHV]

2147483647 I guess.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[willir]

By default, autonumber is a long integer that increments by 1. A long integer uses 4 bytes.

Long Interger, incremental: 0 to 2,147,483,647
(and if you ever reach this number, sequentially, it is time to move to a more robust database)

You can also use...
Long Integer, random: -2,147,483,648 to 2,147,483,647

Lastly, you can also use "Replication ID" as an autonumber (usually used with a master database and replica databases) The replication ID or globally unique identifier that uses 16 bytes which is huuuggggeee. An example... {363AD1A9-2C71-47B9-8F93-B9FD0D555EF6}

Richard

 

[lespaul]

Please try to avoid double posting:

Thread181-1047067

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual