Jump to content
Sign in to follow this  

MS Access

Recommended Posts


I have learned that an easy way to reset autonumbers in a table (so that the next available autonumber is consecutive) is to simply make a copy of the table (structure and data) then delete the original table and rename the copy to the original name. At work I frequently have to do this so I have been trying to figure a way to automate the process using autoit. I can't figure out a way using SQL (doesn't want to let me rename tables ) though I can create a table, move the data, drop the original table, create the table, then move the data back from the second table. The autonumbered fields (indexed id numbers) get whacked in the process. I am still pretty new to this stuff so maybe I am overlooking something.

Has anyone got any ideas of how I can accomplish this?

Thanks in advance.

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this