I know this has already been asked here.
And I also know that MSDN says some wierd way of resettint the AutoNumber it should restart by 1. And I know that if there is No Records in the table it will reset by compacting.
How Could I reset it even if I have 1 or 2 records in the tabe?