Can you reset an Autonumber field in Access ?

[TheBionicOrange]

I've got a table with a field defined as AutoNumber.

This field is the primary key for the table.

I have cleared out all the records, and want to reset the number to 1 before importing new records, but can't work out how to reset it. Can this actually be done, or do I have to define a new table ?

[Ecniv]

Delete all records( you did this) and compact the access db 3 times (dbwindow - menu - tools>Database>Compact or something).


Vince

[TheBionicOrange]

Excellent ! Cheers Vince

Spent the last 10 minutes searching the site for similar problem, but couldn't find an answer that simple.

People were being told to recreate tables and move data over

Not quite sure why you suggested doing it 3 times though, I found once was enough

Thanks again.

[Ecniv]

When you compact an access mdb - it flags those things to change on the first pass (changing counters and stuff.

On the second pass it removes those flagged things (including wasting space of records and reflags some more

On the third pass you've compacted as much as possible

But for your purpose - yup once'll be enough


Vince

[TheBionicOrange]

Well you learn something new every day

Thanks for the info Vince ..... most helpful

[TheBionicOrange]

Thank you Michelle

[GlenW]

Excellent bits of info.
Glad I read this thread.