Renumber AutoNumber field

[riss]

I would like to enquire whether there is any way to
renumber an AutoNumber data type.

Thank you.

 

[Duane Hookom]

Is there a reason why? My application users never see the number so it
doesn't make any difference what the values are. They only need to be
unique. How would you want to change the numbers? Are there records in the
table?

 

[Guest]

After any deletion, I would like to restart the
autonumbering from 1 is this possible?

Thank you!

 

[riss]

After any deletion, I would like to renumber the
AutoNumber list to start from 1 again. Is this possible.

Thank you

 

[Tim Ferguson]

After any deletion, I would like to renumber the
AutoNumber list to start from 1 again. Is this possible.

If you empty the whole table and compact the database, the starting numbver
will be set to one again.

But...

"If you care what value an Autonumber has, then you probably should not be
using an Autonumber"


Tim F