467,880 Members | 1,086 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,880 developers. It's quick & easy.

need help asap

friends,

How can I reset autonumber field in a table?

thanks in advance!

spitfire
Nov 9 '06 #1
  • viewed: 856
Share:
3 Replies
sashi
Expert 1GB
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 1GB
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 8TB
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.

Similar topics

4 posts views Thread by Philip D Heady | last post: by
1 post views Thread by whisper | last post: by
5 posts views Thread by Witless | last post: by
2 posts views Thread by Chad A. Beckner | last post: by
1 post views Thread by Massimo Bonanni | last post: by
4 posts views Thread by briggsie2006 | last post: by
5 posts views Thread by Karthik D V | last post: by
reply views Thread by MrMoon | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.