Home  |  About  |   Search   

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

RunCommand Constants

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.


1998-2009, Dev Ashish & Arvin Meyer, All rights reserved. Optimized for Microsoft Internet Explorer