AutoNumbers are Long Integers, which means they can be
between -2,147,483,648 and 2,147,483,647
To reset, normally all you have to do is compact the database once the table
is empty. However, you really shouldn't have to worry about this. AutoNumber
fields exist for one purpose: to provide a (practically guaranteed) unique
value that can be used as a primary key. It doesn't matter whether that
value is 1,2 3 or 324654, 324656, 324657. Rarely, if ever, is the value of
an Autonumber field shown to the user in a properly designed database.