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

auto number

P: 2
I have built an access databass and during the testing phase I have added a lot of records with the autonumber, now that the databass is ready to use I want the autonumber to start back from 0, how to do that?
thank you in advance.

Carlos
Sep 6 '07 #1
Share this Question
Share on Google+
3 Replies


Jim Doherty
Expert 100+
P: 897
I have built an access databass and during the testing phase I have added a lot of records with the autonumber, now that the databass is ready to use I want the autonumber to start back from 0, how to do that?
thank you in advance.

Carlos

If the table is now empty then compact the database. This resets the autonumber to zero

Tools...database utilities...compact and repair
Sep 6 '07 #2

P: 65
Just for the record: what happens when database ain't empty and you compact it? Does it start from null for the tables that already have autonumbered records in it? I hope it doesn't because I do tons of transactions on my db and they often go wrong, so it leaves a lot of "poisoned" data left that can be removed from the database. If I use compact than my db is cleaned.

Greetz
Twanne

The whole in my head is filled with rocks
Sep 6 '07 #3

Jim Doherty
Expert 100+
P: 897
Just for the record: what happens when database ain't empty and you compact it? Does it start from null for the tables that already have autonumbered records in it? I hope it doesn't because I do tons of transactions on my db and they often go wrong, so it leaves a lot of "poisoned" data left that can be removed from the database. If I use compact than my db is cleaned.

Greetz
Twanne

The whole in my head is filled with rocks
It only applies to empty tables. Tables with data are unaffected
Sep 6 '07 #4

Post your reply

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