D DSmith Dec 1, 2004 #1 Is it possible to re-start an autonumber field with "1" after all the data has been deleted?
K Ken Snell [MVP] Dec 1, 2004 #2 Yes. Compact the database after you've deleted all the records from the table.