Doug Steele
dbdoug at gmail.com
Wed Mar 24 18:40:56 CDT 2010
Build a new empty table with the autonumber field instead of your old id field. Use an append query to add all the records from your old table, appending the old id field to the new autonumber field. Replace the old table with the new. Doug On Wed, Mar 24, 2010 at 4:21 PM, Max Wanadoo <max.wanadoo at gmail.com> wrote: > Hi Guys, > > I have a table with a unique indexed ID with random numbers throughout. > Many blanks in the sequences. > > Some of these IDs are related / cross-referenced to other tables. > > Is there anyway I can change this ID to an Autonumber so that future > records get an autoincremented ID? > > I do not want to change the numbers in there if possible. > > Thanks > > Max > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >