View Full Version : restart autonumeric field to 1


lupitatamayo
05-01-2007, 10:41 AM
hi, after debug some functions in a form, my table has 15 records, after I deleted them my autonumeric field doesn´t start in 1, how can I restart to number 1?

thanks

rainman89
05-01-2007, 10:46 AM
It shouldnt matter if its at one or not, but to fix it. copy your records, then delete them from your table. go to options. compact and repair! that will reset the numbers

Dennisk
05-02-2007, 12:18 AM
Delete all your records, then compact your db and auto numbering should begin at one again.