How can i reset the auto increment value, if i want to add a record and the cancel it using a form in "Add Mode", the auto increment value is continuesly increasing beside i use "Undo Record" command it doesn't rsetting the auto value to its last one.
Note: Compact and repair doesn't work for it in Access-2010
How to reset it.