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

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

Ofer wrote:

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

.