I have a table with an Autonumber field. I can add rows to the table fine, but after the DB is compacted the next Autonumber value Access 2002 tries to use already exists and the insert fails. The only way to fix it is to reset the next autonumber value, but I don't want to have to do this everytime I compact the DB. Anyone else had a similar problem or even know of a solution??