By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,557 Members | 1,184 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,557 IT Pros & Developers. It's quick & easy.

need help asap

P: 2
friends,

How can I reset autonumber field in a table?

thanks in advance!

spitfire
Nov 9 '06 #1
Share this Question
Share on Google+
3 Replies


sashi
Expert 100+
P: 1,754
friends,

How can I reset autonumber field in a table?

thanks in advance!

spitfire
Hi there,

Copy the table structure to a diff table, copy the data as second stage. Good luck & take care.
Nov 9 '06 #2

sashi
Expert 100+
P: 1,754
Hi there,

Another method is as below, hope it helps.

In older versions of Access, you can reset the counter on an AutoNumber field by compacting the database. When this is done, the counter will be reset to the last number used in the table. If you wish to return the counter back to 1, delete all of the records in the table and then perform the compact.

In newer versions of Access, if you compact the database while there are records in the table, the counter will not reset. However, if you delete all of the records in the table and then perform the compact, the counter will return to 1.

To compact an Access database: Under the Tools menu, select Database Utilities > Compact and Repair Database.
Nov 9 '06 #3

Expert 5K+
P: 8,434
friends,
How can I reset autonumber field in a table?
thanks in advance!
spitfire
Just wanted to add something to the other answers. If you are talking about simply resetting the value of the autonumber field on a particular record, then the answer is much simpler - you can't.
Nov 9 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.