I have the problem!!

[cuong]

Hi guys !!!
I am using VB to conect to sql server . now i have the problem that:
I have a table in this table it have a fiedl that is automatic identity incrementally.
for ex :
that fiedl have 5 records : 1,2,3,4,5
every time when i open the form in order to delete 1-4 after that I addnew, i have the new record is 6 . it 's ok for me. it's exactly.
but when I delete 1-5 after that i addnew i have the new record that is : 6 ; so i want to be 1 ( because I have deleted all records,1-5 )but i have the result is 6; it' s not correct for me. so could anybody show me how to do that correctly.
thank

[Rohan_Powle]

It works this way my friend
The counter will go on adding a value no matter u delete previous records the counter will keep on updating...

If u r facing problems u have to delete the indentity field & make a new one to start from one

[Ecniv]

change the field to a number and create your own ID counter. Although this also presents problems...Sometimes.

Regards

Vince