AutoNumber

S

Steve

This is probably a frequently asked question but I can't find an answer. I
am working on a project that has many autonumber type fields used as primary
keys. When I'm done entering test data I'd like to have the numbering start
over at 1 again. How can I reset autonumber fields? Can I make them start
at a different number than 1?

TIA
Steve
 
A

Allen Browne

After deleting the data, compact the database: Tools | Database Utilities |
Compact.

You can start at a number other than 1 by importing a record and specifying
the value 1 less than your starting value. Details in article:
Set AutoNumbers to start from ...
at:
http://allenbrowne.com/ser-26.html
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Autonumber records inserted in gaps 0
One-to-one relationship 2
Design for future merging 13
update number field automatically? 5
2007 Being Weird with AutoNumber 3
new autonumber values already used in table 2
Autonumbering problem - keeps incrementing even though deleted row 5

Top