Resetting AutoNumbers

[peter_m29]

I have been entering records to test my database, but would now like to delete all the test records and get the autonumber fields back to 0(as new fields are now starting at 27!) , so 'real' records can be entered.

Thanks

 

[pbaldy]

Delete the test records, then compact/repair the db. That should reset the autonumber.

 

[o1110010]

I have been entering records to test my database, but would now like to delete all the test records and get the autonumber fields back to 0(as new fields are now starting at 27!) , so 'real' records can be entered.

Thanks

Or copy the table.. paste with only the structure... delete original table.... rename second table to the first table's name.