arfitty
asked on
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
hmm, maybe not......
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
(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.