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:
Can we write truncate command to reset the auto increment values, on MS Access Database?
No..I don't think so.. since MS Access does not support truncate..
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
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
ielts coaching in gurgaon
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
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
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
Awesome story! Congrats on the successful team work!
Deer Hunting Tips Camping Trips Guide DEER HUNTING TIPS travel touring tips
Nice post. it is very interesting and informative. Thank you for the sharing.
Still Hunting Method
Hunting psych tips Survival Tips Travel Touring Tips
Well thanks for the information, do not forget to visit my blog too.
travel trekking tips
see the link Tent Camping 101 Exploring Smithriver
Post a Comment