Auto Number

[Daz]

Is there a way to reset the auto numbering? I import new data then archive the old data. As I do this weekly my auto numbers are getting high and my users do not care for this aspect

 

[plog]

I import new data then archive the old data.

So, whats the point of your auto-number? From the sounds of that sentence it seems you could have duplicate values for this between your "live" data and your "archive" data.

An autonumber is a way to ensure uniqueness in a record. If your user's are privy to it, it would seem you are using it for more than this. Why do they care what the number is? How do they use it?

To answer your question, the best method for your situation would be to compact and repair your database after archiving your data but before importing the new data.

 

[redalert]

What I often do is to have a set up routine that creates some of the tables that are needed in an application. This especially useful if the tables are only required whilst the application is open.

In your routine you could rename the existing table, create a new table using the CREATE TABLE statement (http://msdn.microsoft.com/en-us/library/office/ff837200.aspx), append the data to the new table and delete the renamed table.

This may a bit extreme but it does the trick.

 

[Daz]

Thanks for the information I will try that.