Reset MS Access autonumber

[the_magicien]

How to reset MS Access autonumber type and what is the limit for this autonumber?

Thanks

[hensa22]

data type autonumber is long , search in google max value of 'long'.

it seems be a number so ....... big.

[dglienna]

Remove AutoNumber

Copy your DB
Open your database in Access
Delete the contents of your table
Rename the table
Copy the renamed table (structure only) to a new table

[RobDog888]

Just performa Compact and Repair on your database and that will reset all autonumber fields to the next available number in tables with records in them and it will reset the autonumber to 0 in tables with no records in them.


The number of records possible in a table is dependant upon the tables size, not record numbers. Autonumber can go up to 2,147,483,647 but you will probably never get there as...

table size limits are ...
Access 2003: 2 gigabyte minus the space needed for the system objects.
Access 2002 (XP): 2 gigabytes.
Access 2000: 1 gigabyte.