Reset Index (1 Viewer)

[racdata777]

Can anyone help

I create a database and while testing to see if the Forms and Reports working correct I have to enter some records.

I have set an auto number for Jobcards. After the tests went well how can I reset the auto number "Index" back to 1.

 

[WayneRyan]

arrie,

The autonumber is just a unique identifier for each record.
Generally you should not care what it is, probably won't
display it on forms or reports, etc.

If you dropped the autonumber field, then recreated it
you would start over at 1 again. I also think that after a
compact or repair it will reset.

Wayne

 

[The_Doc_Man]

Wayne is correct. Prior to going "live" with this application, just erase the tables containing test data, then compress the database. Compressing the database resets all autonumbers to the right value based on current contents. If you have erased the tables, the contents are, of course, nil. So you reset the autonumbers.

Wayne is also correct that you should not care if an autonumber field doesn't start at 1 or isn't contiguously numbered.

If you DO care, then the field should not be autonumbered. I.e. an autonumber field should have no meaning external to the record. If it does, you should write something to maintain the meaning of the number because Access won't do so.