RE: How do you reset auto number in a table query?

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

"CAD Fiend" wrote:

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

Relevant Pages