AutoNumber reset ?

[anthonyevans]

Dear All,

When deleting records the AutoNumber for my first field does not reset to the last number of the last field.

i.e. it still reads 6 even though i have deleted 5 records.

How can I have this field reset to the last record number that exists.

Thankyou in advance for your help.

Anthony Evans

 

[HarmonyGirl]

Make a copy of your database first, for safety's sake!

Then, delete all records from your database, and Compact your database. This should reset the Autonumber field.

 

[Atomic Shrimp]

Does it matter that it doesn't reset?

Autonumbers are only intended to provide a unique key in tables which do not naturally contain one, they have no other meaning (as such).

Although it's often nice not to have missing numbers in the sequence, resetting them will cause massive problems if you are using the autonumber field as a key against another table.

Mike

 

[anthonyevans]

thanks Mike. point taken.

Regards,

Anthony