Max AutoNumber Value

Question

What is the maximum number allowed into an autonumber field?

Further, what happens when access reaches this limit... especially as relates to adding a new record after.

Answer

Trevor,

Autonumber is cycling this way (MS Access 97):

1
.....
2147483647
-2147483648	
-2147483647
....
-1
0
1
....

HTH,
Shamil

Copyright © 1999-2008 by Shamil Salakhetdinov. Original version is published here. All rights reserved.