Renumber AutoNumber field

  • Thread starter Thread starter riss
  • Start date Start date
R

riss

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

Thank you.
 
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?
 
After any deletion, I would like to restart the
autonumbering from 1 is this possible?

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

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

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
 
Back
Top