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]
records and started agian, they where [autonumber]
S
strive4peace
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 Access
http://www.AccessMVP.com/strive4peace
*
have an awesome day
*
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 Access
http://www.AccessMVP.com/strive4peace
*
have an awesome day *
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
*
*
Bob said:
- Show quoted text -
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
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
*
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 *