Reset ID Records

I have been working with dummy data and now I want to start using the database for real.  How do I restart the auto numbering of my ID fields from 1?
PowerhousecomputingAsked:
Who is Participating?
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
OR ... just delete ALL the records and then be sure to Compact and Repair ... then the AN will start from 1

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Delete the auto number field in the table, then Compact & Repair the mdb, then recreate the auto number field ... which will result in what you need.

mx
0
 
peter57rCommented:
Delete all records and compact and repair.
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
PowerhousecomputingAuthor Commented:
how do I compact and repair in 2007?
0
 
mikainzCommented:
klick on microsoft menu, under organize you find compact and repair
0
 
PowerhousecomputingAuthor Commented:
yep found it - thanks
0
 
mikainzCommented:
menu entry is called manage not organize
compact.jpg
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.