G Guest Apr 27, 2006 #1 Does anyone remember if and how to reset previously autonumbered records? Thanks.
J John Spencer Apr 27, 2006 #2 Can you be a little more specific about what you need? If you want to reset the autonumber field to start with 1, then delete all the records in the table and compact the database. Or do you want to set the starting number to a specific value? Or do you want to change the autonumber of specific records? For example the field has the value 123 and you want the value to be 10123.
Can you be a little more specific about what you need? If you want to reset the autonumber field to start with 1, then delete all the records in the table and compact the database. Or do you want to set the starting number to a specific value? Or do you want to change the autonumber of specific records? For example the field has the value 123 and you want the value to be 10123.
