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

How to reset an Auto Number to ZERO 2

Status
Not open for further replies.
sylvain

sylvain

Technical User
Mar 20, 2001
39
CA
I have a database that i want to restart, how can i reset my autonumber field to Zero???

Thanks for you help
 
Sort by date Sort by votes

simplest way off top of head would be to simply drop and then add the column again ..
Ben
+61 403 395 052
 
Upvote 0 Downvote
Allo Sylvain,
Make a copy of your table "structure only". take a look at it (well, it will be ready to start at 1) and then if you have data, run an Append query in to the copy for every field except the AutoNumber. :) Gord
ghubbell@total.net
 
Upvote 0 Downvote
You can drop the autonumber column and add it again. John Fill
 
Upvote 0 Downvote
Done!!!!

Thanks all for your help

ghubbell tips works perfectly...

s-)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

YoBi4Ever
  • Locked
  • Question
I would like to compute how many minutes or hours the employee left work by comparing two records
Replies
3
Views
368
dhookom
dhookom
lmcate
  • Locked
  • Question
How to Open ACCESS (MDB) from an HTML Page 1
Replies
2
Views
4K
lmcate
lmcate
TheresAlwaysAWay
  • Locked
  • Question
Can Access be used to generate and respond to text messages? 1
Replies
6
Views
4K
TheresAlwaysAWay
TheresAlwaysAWay
renigar
  • Locked
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
953
renigar
renigar
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
6K
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top