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

Reset autonumber counter

Status
Not open for further replies.
Knutjo

Knutjo

Programmer
Jan 15, 2002
31
NO
During developing a database I do some tests and the autonumber counters is increasing.
How can I reset the autonumber - counter before installing the database at the end user site
 
Sort by date Sort by votes
If you delete all the records from a table and then compact the DB, the autonumber will be reset... Terry
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ksam14714
  • Locked
  • Question
counter Customer ?
Replies
3
Views
152
ksam14714
ksam14714
MrMode
  • Locked
  • Question
Setting starting value of COUNTER via a textbox 1
Replies
6
Views
237
MrMode
MrMode
PizMac
  • Locked
  • Question
reset an empty counter/autonumber to 1 without compacting 1
Replies
5
Views
250
PizMac
PizMac
FancyPrairie
  • Locked
  • Question
How to I determine if a field (ADODB recordset) represents an autonumber? 1
Replies
2
Views
227
FancyPrairie
FancyPrairie
vba317
  • Locked
  • Question
Loop counter not working properly 1
Replies
2
Views
110
vba317
vba317

Part and Inventory Search

Sponsor

Back
Top