Access autonumbering has reset sequence
Have a small (<200 records) Access 2003 database with an autonumber ID. Some numbers in the series are missing (having been deleted). On entering new record, autonumber moves from #188 to #51449369! Is there a way to reset the sequence from #189 without changing the previous series?
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
jerryb30
hmm, maybe not......
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
(I doubt it is random. There are so many more numbers above his number or >0 .)
I was not correct, in that a pure compact/repair does not fix thing, although thanks for saying so.
I was not correct, in that a pure compact/repair does not fix thing, although thanks for saying so.
(I doubt it is random. There are so many more numbers above his number or >0 .)
But the Random flag just tells Access to build an Autonumber based on some seed value (believe the Time is factored in somehow also) ... I've seen them run from -10000000 to + 4500000 (appx) with just adding one record ...
But the Random flag just tells Access to build an Autonumber based on some seed value (believe the Time is factored in somehow also) ... I've seen them run from -10000000 to + 4500000 (appx) with just adding one record ...
ASKER
Took pragmatic approach and re-set the ID field.
agree.
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
