I have an Access DB that has an autonumber field that assigns records a number (ie 1,2,3) in order of creation. My question is this. How can I basically wipe out all data and start from scratch so that record 1 is available again? I've tried just deleting the records but for some reason the autonumber won't go back to 1 after all records have been cleared. I've also tried changing it to a number field, saving and switching back. Thanks in advance.