Jump to content
Sign in to follow this  
tunaroll

MS Access

Recommended Posts

tunaroll

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  

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.