How do I reset the auto number field after deleting records

  • Thread starter Thread starter Guest
  • Start date Start date
Componcall said:
How do I reset the auto number field after deleting records
Click to expand...

Compact the database. However:

I suggest you may not want to use Autonumber for that use. Autonumbers are
designed to provide unique numbers. It in not designed to provide numbers
in order and for a number of reasons may not do so. As a result using them
in any application where the user sees the numbers is likely to end up with
confusion.

There are other ways of providing the numbers you want depending on the
particual application.
 
Componcall said:
How do I reset the auto number field after deleting records
Click to expand...

Try to Compact the DataBase.
The AutoNumber Field restart from it's default start value.
 
Compact and repair of the Mdb where the table located in, will do the trick
But it will only reset it up to the last record, so if you deleted the all
table, it will reset it back to 1, if the last record AutoNumber is 501 and
you delete the last 2 records it will reset the number back to 500.

But if you delete records in the middle it will stay empty.
 
Back
Top