add

Wednesday, December 23, 2009

How to reset the autoincrement field in MS Access Table

How to reset the autoincrement field in MS Access Table

Many times we use autoicrement field in Ms Access table and we have noticed that the value of autoincrement field keeps on increasing ever if we delete all the rows of the table and add new row.
In order to reset the autoincrement field value back to 1, do the following:

1. Delete all the rows from the table.
2. Compact the whole database .

This will automatically reset the autoincrement value back to 1.

11 comments:

Manab Ranjan Basu said...

Can we write truncate command to reset the auto increment values, on MS Access Database?

Varun Sharma said...

No..I don't think so.. since MS Access does not support truncate..

Grija said...

This is really a great post. Thank you for taking time to provide us some of the useful and exclusive information with us. Keep on blogging!!


Dotnet Training in Chennai

Unknown said...

Wow it is really wonderful and awesome thus it is very much useful for me to understand many concepts and helped me a lot. it is really explainable very well and i got more information from your blog.

Java training in Chennai | Java training institute in Chennai | Java course in Chennai

Java training in Bangalore | Java training institute in Bangalore | Java course in Bangalore

Java online training | Java Certification Online course-Gangboard

Java training in Pune

akash thakur said...

ielts coaching in gurgaon

Mounika said...

It is better to engaged ourselves in activities we like. I liked the post. Thanks for sharing.

Python training in bangalore
Python course in pune
Python training in bangalore

Unknown said...

Thanks a lot for sharing us about this update. Hope you will not get tired on making posts as informative as this. 
Data Science training in chennai | Best Data Science training in chennai
Data Science training in OMR | Data science training in chennai
Data Science training in chennai | Best Data science Training in Chennai
Data science training in velachery | Data Science Training in Chennai
Data science training in tambaram | Data Science training in Chennai
Data Science training in anna nagar | Data science training in Chennai

Revathy said...

Very good brief and this post helped me alot. Say thank you I searching for your facts. Thanks for sharing with us!

angularjs Training in bangalore

angularjs Training in btm

angularjs Training in electronic-city

angularjs online Training

angularjs Training in marathahalli

angularjs interview questions and answers

Unknown said...



Awesome story! Congrats on the successful team work!
Deer Hunting Tips Camping Trips Guide DEER HUNTING TIPS travel touring tips

Unknown said...


Nice post. it is very interesting and informative. Thank you for the sharing.

Still Hunting Method
Hunting psych tips Survival Tips Travel Touring Tips

Unknown said...



Well thanks for the information, do not forget to visit my blog too.

travel trekking tips
see the link Tent Camping 101 Exploring Smithriver