How do you reset auto number in a table query?

  • Thread starter Thread starter CAD Fiend
  • Start date Start date
C

CAD Fiend

Hello,

I am testing a table structure, and want to delete all of the records,
which are primary keyed with auto number. If I just delete the records,
and create a new record, it picks up whatever the last record number
was. I remember once that I had to do a query to clear that index. BTW,
does it make any differnce if the primary key is indexed (duplicates
OK?)

TIA.

Phil.
 
Delete all the records in your table.
Compact the database.
Enter a new record... the AutoNumber should start again at 1.
 
Manual method ---

Open your table in design view, delete the primary key then type (or paste)
it back in. The PK will again start at 1.
 
Back
Top