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

auto-number back to zero

Status
Not open for further replies.
quibus

quibus

Technical User
Jul 18, 2002
8
BE
Hey,

I just finished my access-database. I use auto-numbering. I finished testing and now I want to reset the auto-numbering back to zero, so I can start filling in the real data.
How do I reset this back to zero???
Sorry... just a beginner at work!!!
 
Sort by date Sort by votes
hi,

to be able to reset an autonumber field, you have to empty the table and Compact the database (Tools menu) Mal'chik [bigglasses]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheresAlwaysAWay
  • Locked
  • Question
Can Access be used to generate and respond to text messages? 1
Replies
6
Views
3K
TheresAlwaysAWay
TheresAlwaysAWay
renigar
  • Locked
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
693
renigar
renigar
YoBi4Ever
  • Question
I would like to compute how many minutes or hours the employee left work by comparing two records
Replies
3
Views
201
dhookom
dhookom
TheresAlwaysAWay
  • Locked
  • Question
Crazy question: Can anyone help me create a routine to roll 2 dice 1000x and sum them? 4
2
Replies
22
Views
4K
Andrzejek
Andrzejek
lmcate
  • Locked
  • Question
How to Open ACCESS (MDB) from an HTML Page 1
Replies
2
Views
3K
lmcate
lmcate

Part and Inventory Search

Sponsor

Back
Top