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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Resetting the autonumber

Status
Not open for further replies.
jpmillr1

jpmillr1

Technical User
Jun 13, 2003
12
0
0
US
Is there a way to reset the autonumber to Zero? I have a test database that is up to 30 or 40, and I want to reset the count to Zero to roll it out. Thanks.

JP
 
Sort by date Sort by votes
You can delete all the data from the tables (where you want it reset to 0 - first record would become 1) and then compact your database. This will reset the autonumbers to the lowest number available...if empty, this is 0.

Ellie
**Using Access 97 at work**
**Using Access 2000 at home**

elliefant@qwest.net
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question
Using old IDs as Autonumbers 1
Replies
6
Views
127
Andrzejek
Andrzejek
v5652
  • Locked
  • Question
Trouble opening database Make sure the drive is available
Replies
2
Views
104
v5652
v5652
MrMode
  • Locked
  • Question
Table locked after inserting a record with autonumber field value
Replies
2
Views
45
MrMode
MrMode
BLSguy
  • Locked
  • Question
Referencing Totals from One Table in the Fields of Another
Replies
2
Views
50
BLSguy
BLSguy
cortextual
  • Locked
  • Question
Referential integrity issue: no unique index found for the referenced field of the primary table
Replies
2
Views
103
MajP
MajP

Part and Inventory Search

Sponsor

Back
Top