Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Resetting Autonumber!

Status
Not open for further replies.
RWB42

RWB42

Technical User
May 12, 2002
20
US
I have made a simple database and added some records. Next I have created a copy of that database and removed ALL records. Now that I have a new, empty of records, database I want to enter new data. Unfortunately, the AUTONUMBER field starts from where the OLD data records left off. Any idea how to reset the AUTONUMBER?

Thanks in advance!!!
 
Sort by date Sort by votes
I already find my own answer. I just went under TOOLS, DATABASE UTILITIES, COMPACT AND REPAIR DATABASE. The database AUTONUMBER resets to 1.
 
Upvote 0 Downvote
I already found my own answer! I just went under TOOLS, DATABASE UTILITIES, COMPACT AND REPAIR DATABASE. The database AUTONUMBER resets to 1.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question
Using old IDs as Autonumbers 1
Replies
6
Views
420
Andrzejek
Andrzejek
MrMode
  • Locked
  • Question
Table locked after inserting a record with autonumber field value
Replies
2
Views
117
MrMode
MrMode
puforee
  • Locked
  • Question
Emergency...Autonumber field repeating when ne record is added...Error messages
Replies
1
Views
86
puforee
puforee
BoulderRidge
  • Locked
  • Question
AutoNumber field AND unique index field contain a duplicate value in my table
Replies
5
Views
129
BoulderRidge
BoulderRidge
ColdDay
  • Locked
  • Question
Benefit of using an AutoNumber field.
Replies
5
Views
112
BNPMike
BNPMike

Part and Inventory Search

Sponsor

Back
Top