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
thanks
|
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. |