Auto Increment Reset

[Sibtain]

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.

[RuralGuy]

Said better that I could say it: http://www.utteraccess.com/forum/Aut...t-t443604.html

[khalid]

One way is to create the un-bound form. Type/Fill all the fields in a un-bound fields on a form, and on button click event on the form, save the data to your table using INSERT INTO table Statement.

INSERT INTO table_name (column1, column2, column3,...)
VALUES (value1, value2, value3,...)

This will fire/increment the Autonumber id only once. Autonumber Field should not be included in the Insert Statement. Access is generating it automatically when new record is inserted.

[sandip]

Hello Friends,

You can reset AUTOINCREMENT field by 'ALTER TABLE' query in MS Access.

Example:

alter table tblName alter column clmName AUTOINCREMENT(a,b);

Here,
-> 'a' is initial number to start with and
-> 'b' is increment for each next value..

Thank you.