Resetting Autonumber

  • Thread starter Thread starter Jamie
  • Start date Start date
J

Jamie

A friend of mine has a database that meets my exact needs. I copied/pasted
it onto my computer. I erased all his records to enter my own data. However,
he had an ID number set to Autonumber and now when I enter new data, it is
still continuing to give it his numbers. In otherwords, I want the
Autonumber to start back at 1 but it goes to 506 (where he left off). Any
ideas?
 
Delete all Records and the do a Compact and Repair.

However, the only purpose of the AutoNumber is to provide uniqueness to each
Record in the Tables. Therefore, the actual value allocated to each Record
should NOT matter at all. In fact, my users don't see the values of the
AutoNumber Fields.

If the values matter to you, AutoNumber Fields may be the wrong one to use
as AutoNumber can become random or even negative. Check these newsgroups or
Google for "Custom Number Sequence" which is a more suitable solution in
this case.
 
Thanks for your response.
The reason why I want to start at 1 and use autonumber is so I can get an
accurate count of my records at a glance and generate a report with that
data.

Jamie
 
Then Autonumber isn't the correct thing for you.

They are NOT guaranteed to be sequential: in fact, if you start to add a
record and change your mind, you will lose the number that would have been
assigned.
 
Back
Top