is it possible to reset the starting value of an auto- number field? if so, how? thanks
M mike Aug 11, 2003 #1 is it possible to reset the starting value of an auto- number field? if so, how? thanks
F Fredg Aug 11, 2003 #2 Mike, The actual number should be irrelevant. The only important thing about an Autonumber field is that each record have a different unique number. To reset the AutoNumber field to 1, delete all the records in the table (not the table itself). Then compact the database.
Mike, The actual number should be irrelevant. The only important thing about an Autonumber field is that each record have a different unique number. To reset the AutoNumber field to 1, delete all the records in the table (not the table itself). Then compact the database.
