By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,647 Members | 1,178 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,647 IT Pros & Developers. It's quick & easy.

How to set auto increment to 1 ???

100+
P: 111
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..
Aug 21 '07 #1
Share this Question
Share on Google+
1 Reply


Rabbit
Expert Mod 10K+
P: 12,355
You can't, at least not with autonumbers. But you can do what you want with code.
Aug 21 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.