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

From: Shamil Salakhetdinov <shamil@marta.darts.spb.ru>
To: Microsoft Access Database Discussion List <ACCESS-L@PEACH.EASE.LSOFT.COM>
Subject: Re: Max AutoNumber Value
Date: 24 April 1998 9:53

Trevor,

Autonumber is cycling this way (MS Access 97):

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

HTH,
Shamil