Access: Reset auto value field - how it works

Thanks to the auto value in Access, all fields are numbered automatically. To reset the field, you only have to click a few times. In this practical tip, we show you exactly how to proceed.

Reset auto value field in database at Access

1. Start the program as usual and open the respective database via "File"> "Open".
2. Press Ctrl + A to select the entire database. Alternatively, you can also click "Mark"> "Mark All".
3. Then switch to "Data records" and select "Delete" here. Confirm this process.
4. After the records have been successfully deleted, click on the "Database Tools" tab.
5. To be able to reset the auto value, select "Compress and repair database" here.