General: Reset Autonumber field in Table

Home | French | About | Search | mvps.org


	What's New Table Of Contents Credits Netiquette 10 Commandments Bugs Tables Queries Forms Reports Modules APIs Strings Date/Time General Downloads Resources Search Feedback mvps.org In Memoriam Terms of Use

General: Reset Autonumber field in Table	Author(s)
	Dev Ashish


(Q) How do I set the Autonumber field in my table so that it starts from 1 again? (A) If your table does not contain any records, simply compacting the database again will set the Autonumber field back to 1. Another way would be to delete the AutoNumber field and re-insert it in the table.