Reset autonumber to zero

J

joseph

Hello,

Is there a method to reset the autonumber back to zero in the tables that contain the autonumber field.I have populated the tables with entries to test it out and now i would like to reset the autonumber.Is this possible?
Thanks for the support!
 
K

Ken Snell

Delete all records from the table, then do a compact and repair.

--
Ken Snell
<MS ACCESS MVP>

joseph said:
Hello,

Is there a method to reset the autonumber back to zero in the tables that
Click to expand...
contain the autonumber field.I have populated the tables with entries to
test it out and now i would like to reset the autonumber.Is this possible?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Missing fonts after computer reset 3
VBA - (re-) Set a Table Style 2
Excel VBA to delete records in Access table and reset the Autonumber 1
MS Outlook inbox to MS Accsess Database 0
How can I reset my normal template it its default. 1
new autonumber values already used in table 2
Multiple Text Fields - i.e. "Figures" and "Tables" 1

Top