Auto reset the value of field in database in Access
- You start the program as usual and open them via "file" > "Open" the database.
- Press [Ctrl] + [A] press to select the entire database. Alternatively, you can also click mark to Mark > "Everything".
- Then go to "records" and select "Delete". You to confirm the operation.
- After the records have been successfully deleted, click on the Tab "database tools".
- To be able to set the auto-reset value, select "database compress and repair".
Access: AutoNumber field to reset
This practical tip is based on Office 2010 on Windows 7. You will learn in the next practice tip on how you Access tables together add can.
