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

Reset Field Autonumbering

P: n/a
Hey is there a command like in SQL Transactional that will reset the
Autonumber field to the highest number in the found in the field?

I developing a access database with a several table that have
autonumbering. I would like to reset them back to 0 after I delete
all the rows of data. Is there an easier way to do this other than
creating a new field and remove the old autonumber? Maybe in the
system table?
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
After you remove all the records click the main menu Tools/Database
Utilities/Compact and Repair. The numbers will start over at 1.

--
Reggie

----------
"N. Graves" <ng*****@REMOVEyahoo.com> wrote in message
news:ld********************************@4ax.com...
Hey is there a command like in SQL Transactional that will reset the
Autonumber field to the highest number in the found in the field?

I developing a access database with a several table that have
autonumbering. I would like to reset them back to 0 after I delete
all the rows of data. Is there an easier way to do this other than
creating a new field and remove the old autonumber? Maybe in the
system table?

Nov 13 '05 #2

P: n/a
I've never seen another way besides dropping the field and recreating
it. In some cases, I've seen where simply dropping the field didn't
reset it. In those cases I had to drop the autonumber field, compact
the database, then recreate the autonumber field.

James

N. Graves <ng*****@REMOVEyahoo.com> wrote in message news:<ld********************************@4ax.com>. ..
Hey is there a command like in SQL Transactional that will reset the
Autonumber field to the highest number in the found in the field?

I developing a access database with a several table that have
autonumbering. I would like to reset them back to 0 after I delete
all the rows of data. Is there an easier way to do this other than
creating a new field and remove the old autonumber? Maybe in the
system table?

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.