Resetting Autonumber values

[verticalclimb]

I cleared a table of records and need to restart (at one) the autonumber field. I used the instructions found on on-line help but they will not reset the field back to one. Any one have a solution. I have even deleted the field and created a new one with the same name and it started with the same value it would hav used before I deleted any records.

 

[systemx]

Delete all records from your DB, then perform a compact & repair from the database tools menu.

Regards,

Rob

 

[verticalclimb]

Beautiful, that worked great. thanks a million.

 

[Bat17]

if you care what the numbers are in an autonumber field then you are probably not using it correctly

Autonumbers on guarantee a set of unique numbers not consecutive ones. if a record is canceled/deleted/pc crashes before record is saved you will get a gap.

Pete