Link to home
Start Free TrialLog in
Avatar of arfitty
arfittyFlag for New Zealand

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
Avatar of jerryb30
jerryb30
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
hmm, maybe not......
SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
(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 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 ...
Avatar of arfitty

ASKER

Took pragmatic approach and re-set the ID field.  
agree.