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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

AutoNumber 7
Autonumbering Old Records 2
Chaplain Doug 3
AutoNumber Field Broken: How To Fix? 9
renumber a field with addins and deletions 2
Help with Autonumber 2
How can I renumber my autonumbered fields and the linked tables 3
Renumbering 1

Back
Top