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


P: 121
I have a field with department id and the data type is autonumber
now i have put some values in the table for eg 2 records now the next department id is 3
when i deleted two records and i added once again a record now department id is 3.i want to start it from 1 how to do it
Feb 18 '08 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 1,134
Simply deleting the records and turning the field off auto number save and turn auto number back on. Sorry to say that dosn't work.

Rename the original table, copy it and paste it into the tables area ensuring that the structure only option is selected and you give it the name of the original table. Now that does work. At least memory tells me it works.
Give that a go
Feb 18 '08 #2

Post your reply

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