• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1182
  • Last Modified:

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?
0
Powerhousecomputing
Asked:
Powerhousecomputing
  • 2
  • 2
  • 2
  • +1
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
OR ... just delete ALL the records and then be sure to Compact and Repair ... then the AN will start from 1

mx
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

  • 2
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now