Restarting the autonumber at 1

[marathonlady]

I have been developing an access db that uses autonumbers in
every table (about 10 tables). Now that it is going into production next week, I want to start all tables out with 1 as the first autonumber for the first record. How do I do that?

Thanks in advance.

 

[RV]

This issue is rather detailed described in Access Help.
Just look for autonumber.
Come back if you need further help.

RV

 

[Rich]

Delete all the records and compact the db