How to set auto increment to 1 ???

[rhepsi]

hii all,

i have created a database with a table with number of fields....in msaccess

ive set primary key as SNo: and its datatype as auto number...


How to set the auto increment ????

For ex:

i have inserted few records... say 5

and i deleted one record... when i insert new record nw.... the no. would be 6...

how to set it to 5...

1 more thing ... thru ms access can we set the auto increment,,,, not thru any code
plz help..

thnx..
hepsi..

[Rabbit]

You can't, at least not with autonumbers. But you can do what you want with code.