View Single Post
  #2 (permalink)  
Old June 30th, 2006, 07:03 AM
SerranoG SerranoG is offline
Friend of Wrox
Points: 4,007, Level: 26
Points: 4,007, Level: 26 Points: 4,007, Level: 26 Points: 4,007, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG

If you clear the table completely and then compact and repair the database, it'll always reset to 1. You cannot force it to start elsewhere nor guarantee that the numbers will always be sequential, especially when you start deleting data in the middle.

Autonumbers are not meant to hold any meaningful value at all. Their purpose is merely to set a unique identifier to the record so you can reference it. Therefore, you'd never worry about where it starts or if it's a "logical" number.

If you need a number that has meaning, create your own indexed field in the table and populate it yourself. Don't use autonumber.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
Reply With Quote