Autonumbers

[Hanne Otterdal]

I've got a table Person with a primary key PersonID,
datatype Autonumber. After adding 70 records to the
table, suddenly the next PersonID was assigned the value
453054364 instead of increasing the autonumber with one.
Any ideas why??? With a PersonID this high, I get an
Overflow-error every time I try to search for a person...

 

[Dan Artuso]

Hi,
Auto numbers are guaranteed to be unique and not much else.
Their data type is long integer, so declare any variables you use
with them as Long.