Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Reset primary key
0 views
Skip to first unread message
Chua ML
Aug 12, 2002, 3:01:58 PM8/12/02
to
I m testing my database by inputing test values in the
form using ACCESS97. The primary key has been incrementing
ever since.
form using ACCESS97. The primary key has been incrementing
ever since.
How do I reset the primary key to 0 when I have finished
testing?
Thanks!
Regards
Ivan
Joan Wild
Aug 12, 2002, 5:27:42 PM8/12/02
to
You can empty the tables, and then compact the database (Tools menu).
However, you shouldn't care what the value of an autonumber is, as there
will always be gaps.
Joan Wild
Access MVP
"Chua ML" <min...@yahoo.com> wrote in message
news:13cc01c24232$bbeee9b0$36ef2ecf@tkmsftngxa12...
0 new messages