Table Record Autonumber 2

[uconn1981]

Hi, All:

I have a Table with autonumber field. If i deleted some records, how can i reorder the autonumber field? The Access does not automatically do that. For example, originally I have records from 1 to 20. If i delete record number 3 and 4, the autonumber field will not reorder the number 5 and 6 to 3 and 4 and so on.

Thanks,

Tim

 

[PHV]

An autonumber field should not have any other meaning than to be unique.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Golom]

There is no facility to resequence autonumbers other than to restart them at 1 by deleting all the records in the table and then compacting the database.

If you want to have the ability to resequence numbers then you will need to generate your own numbers and write code to do the resequencing.