F Fredg Nov 6, 2003 #2 Renumber to what? To 0? Delete all the records in the table (not the table itself), Compact the database.
Renumber to what? To 0? Delete all the records in the table (not the table itself), Compact the database.