How do I reset autonumber field in access 2003?

Question

score 2 · Answer 1 · edited Oct 14 '13 at 14:56

2

Use the "compact and repair" process. This will reset the auto increment back to 0 (for empty tables that is). If the table is still populated with records you don't want to reset the counter i think...

It can be found under: Tools >> Database Utilities >> Compact and Repair Database

edited Oct 14 '13 at 14:56

Matthew Lock

4,757

answered Mar 10 '10 at 14:16

S.Hoekstra

2,419

score 1 · Answer 2 · answered Mar 10 '10 at 14:18

1

A quick "totu" here with few ways to reset it. From Microsoft KB:

http://support.microsoft.com/kb/812718

"I can't paste it here since it's in french for me"... sorry!

answered Mar 10 '10 at 14:18

r0ca

5,833

score 0 · Answer 3 · answered Mar 18 '10 at 23:07

0

If you are having index problems or wish to reset an autonumber seed to a sepcific value for unusual reasons see Set AutoNumbers to start from ...

answered Mar 18 '10 at 23:07

Tony Toews

434

How do I reset autonumber field in access 2003?

3 Answers3

Linked