Solved

Reset ID Records

Posted on 2008-10-03
7
1,146 Views
Last Modified: 2011-10-19
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
Comment
Question by:Powerhousecomputing
  • 2
  • 2
  • 2
  • +1
7 Comments
 
LVL 75
ID: 22631921
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
 
LVL 77

Expert Comment

by:peter57r
ID: 22631924
Delete all records and compact and repair.
0
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 500 total points
ID: 22631928
OR ... just delete ALL the records and then be sure to Compact and Repair ... then the AN will start from 1

mx
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

Author Comment

by:Powerhousecomputing
ID: 22631956
how do I compact and repair in 2007?
0
 
LVL 8

Expert Comment

by:mikainz
ID: 22632083
klick on microsoft menu, under organize you find compact and repair
0
 

Author Comment

by:Powerhousecomputing
ID: 22632098
yep found it - thanks
0
 
LVL 8

Expert Comment

by:mikainz
ID: 22632103
menu entry is called manage not organize
compact.jpg
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now