Reset Auto Number In Database (1 Viewer)
- Thread starter fish001
- Start date
NauticalGent
Ignore List Poster Boy
- Local time
- Today, 01:47
- Joined
- Apr 27, 2015
- Messages
- 6,317
Convert the SP list to a local table.
Delete to PK (Autonumber) field.
Compact and Repair the DB.
Add the PK (Autonumber) field to the table
Export the table to SP
Re-link the SP list
Go forth and sin no more...
Delete to PK (Autonumber) field.
Compact and Repair the DB.
Add the PK (Autonumber) field to the table
Export the table to SP
Re-link the SP list
Go forth and sin no more...
- Local time
- Today, 00:47
- Joined
- Feb 28, 2001
- Messages
- 27,122
Note that if you had ANY LINKS AT ALL to the autonumber field, you broke all of the links when you erased and then renumbered the field.
Further, this kind of treatment USUALLY means you are using the autonumbered field for a purpose inappropriate to that kind of field. An autonumbered PK is supposed to be unique and generally increasing but there is NO GUARANTEE of monotonic increases. There can be gaps. If you can't handle the gaps, you should not be using autonumbers.
Further, this kind of treatment USUALLY means you are using the autonumbered field for a purpose inappropriate to that kind of field. An autonumbered PK is supposed to be unique and generally increasing but there is NO GUARANTEE of monotonic increases. There can be gaps. If you can't handle the gaps, you should not be using autonumbers.
NauticalGent
Ignore List Poster Boy
- Local time
- Today, 01:47
- Joined
- Apr 27, 2015
- Messages
- 6,317
Ego te absolvo!
- Local time
- Today, 01:47
- Joined
- Feb 19, 2002
- Messages
- 43,196
Do we have a covey of alter boys or did you all study Latin?
- Local time
- Today, 00:47
- Joined
- Feb 28, 2001
- Messages
- 27,122
Possum dicere Latinam linguam.
And I'm not even Catholic!
And I'm not even Catholic!
NauticalGent
Ignore List Poster Boy
- Local time
- Today, 01:47
- Joined
- Apr 27, 2015
- Messages
- 6,317
Alter boy in another lifetime. I actually heard Father Holloway issue those words to someone in the hospital. Always thought it strange that a mortal man had that kind of power...
- Local time
- Today, 00:47
- Joined
- Feb 28, 2001
- Messages
- 27,122
Mark, that is "IN nomine patri et fili et speritus sancti" I believe.
Mr. Hein (my H.S. Latin teacher) would be so proud of me.
Mr. Hein (my H.S. Latin teacher) would be so proud of me.
- Local time
- Today, 00:47
- Joined
- Feb 28, 2001
- Messages
- 27,122
Ja, ich kann Deutch sprechen aber nicht sehr gut. Ich nicht genug Worte haben.
Ich kann sie verstehen als sie langsammer sprechen.
Ich kann sie verstehen als sie langsammer sprechen.
Similar threads
