How do you reset auto number in a table query?

[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.

 

[Guest]

You need to compact the MDB, that will reset the counters

 

[CAD Fiend]

OK. I'll try that. But is that the only way?

You need to compact the MDB, that will reset the counters

 

[Guest]

You can't have duplicates on your primary key.

OK. I'll try that. But is that the only way?

 

[Al Camp]

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

 

[PC Datasheet]

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.