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

Autonumber

Status
Not open for further replies.
sarath77

sarath77

Programmer
Apr 21, 2002
4
0
0
DE
Hello

I have a field called ID(Primary Key) in my table which is an autonumber.I deleted all the exsisting records and then try to add new records,but the no is incrementing from the previous one rather than from 1.
how should i change this?

Thanking you
 
Sort by date Sort by votes
From the tools menu, select database utilities, and compact or compact & repair. This will reset your autonumber.

Cheers,
Jols
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

weightinwildcat
  • Locked
  • Question
Error 3061 and AutoNumber field.
Replies
2
Views
42
PWise
PWise
weightinwildcat
  • Locked
  • Question
Get value from autonumber field once a record has been copied.
Replies
3
Views
41
Andrzejek
Andrzejek
tbclbd
  • Locked
  • Question
Access 2010 - problem with Autonumber fields
Replies
6
Views
29
Hap007
Hap007
sjp0362
  • Locked
  • Question
AutoFill and/or AutoNumbering - Access 2007
Replies
1
Views
14
dhookom
dhookom
rodrunner79
  • Locked
  • Question
Create an autonumber with First Character as Prefix (e.g. A000001) 2
Replies
8
Views
25
PHV
PHV

Part and Inventory Search

Sponsor

Back
Top