Getting records to start from 1

B

Bob Vance

How can I get my records to start from 1 again after I deleted all my
records and started agian, they where [autonumber]
 
S

Scoop

Hi Bob,

Compact and Repair the database to reset the autonumber counter

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Accesshttp://www.AccessMVP..com/strive4peace

  *
    :) have an awesome day :)
  *



Bob said:
How can I get my records to start from 1 again after I deleted all my
records and started agian, they where [autonumber]- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...

Or, if you didn't delete ALL of the records and need to re-number, you
can change the existing autonumber field to number, create another
autonumber field, run an update query to update values in
corresponding tables, then delete the original field.
 
J

John W. Vinson

How can I get my records to start from 1 again after I deleted all my
records and started agian, they where [autonumber]
Click to expand...

It shouldn't matter. Autonumbers have one purpose, and one purpose ONLY: to
provide a meaningless unique key. If you're trying to use them as a record
count, or assuming that they will be reliably sequential, you'll be
disappointed; even starting a new record and pressing <Esc> to cancel it will
"use up" an autonumber. They're simply not designed for display, and should
best be kept "under the hood" and not exposed to user view. A primary key
value of 33129 is just as useful as 1 for its intended purpose.
 
S

strive4peace

Hi John,

yes, this is true -- but I also like my numbers to start at 1 because
the IDs are easier to remember for testing ;)

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
:) have an awesome day :)
*
 
Top