Hi!



Well, in Access there is...the Autonumber datatype is Long Integer which

means from -2,147,483,648 to 2,147,483,648. This gives you about 4 billion

possible values. Practically, if you have auto increment by 1 and not random

numbers, it will give you about 2 billion values...



Hakan



-----Ursprungligt meddelande-----

Från: gary marcos [mailto:gary_marcos@y...]

Skickat: den 13 oktober 2001 20:00

Till: ASP Databases

Ämne: [asp_databases] autonumber limit?





Is there a limit to how big an autonumber can grow?  Is it in the millions?

Is this a legitimate problem to worry about or will the Sun supernova

before this happens?

thanks,

Gary