AutoNumber

  • Thread starter Thread starter Steve
  • Start date Start date
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
 
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
 
Back
Top