Printable View
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?
I don't think u can ...
It must be a way.
How does the Jet engine store what has to be the next Number, maybe I could change that.
Well you could delete the realtionships based on the autonumber field, then delete the field. Add a new field as autonumber, rename it the same name as the original autonumber field. Finally recreate the relationships.