i have an autonumber as the primary key in an access 2000 database and occasionally i want to delete all of the records and repopulate the data. however when i add the new data the first records id is one greater than the last one. is there any way to reset the autonumber so that the first record&#039s id is always 1