autonumber fields

P

ping

got a question.

what happens if an sequential autonumber field size set to
long integer has so many entries that all the numbers get
used up?

thanks
 
D

Dan Artuso

Hi,
Seeing as the upper limit for a long is:
2,147,483,647
and the lower limit is:
-2,147,483,647

I somehow doubt that you'll ever have 4 billion records in one table.
I've never heard of anyone ever having had that problem.
 
V

Van T. Dinh

Since the size limit of an Access database is 2 GB (2 x 10 ^ 9 bytes), you
will have a lot of other problems before you run out of valid values (4 x 10
^ 9) for AutoNumber Field.
 
P

ping

i notice that autonumber fields keeps incrementing even though previous
record eg. record 48 has been deleted, next autonumber record doesnt fill in
the 48, but increments from the last record entered.

what im wondering is, if it reaches the upper limit, will it start from the
lower limit and climb up again? or fills up those previously deleted numbers?
or come out with an error?
 
P

ping

just thinking if in event of a very high volume transactions, lots of records
are inserted and deleted in a day.
when an autonumber field reaches the upper limit, will it restart from the
lower limit and climb upwards, or does it fill up those previously deleted
autonumber records? or will it generate an error?
 
Top