Question Autonumber reset after import

Linda2431

Registered User.
Local time
Today, 15:29
Joined
Dec 27, 2012
Messages
27
I have a BE database that we have been using for over a year. I imported data from an external database into this database. Now I've found that my Autonumber has reset to a very low number -- that was imported from my external database. Is there a way to change this autonumber BACK to what it was and increment up? The lowest autonumber in this database is 275944, so I don't have to worry about duplicates in the near future. I would like it reset to 457230, or at least higher than that number.
Thank you!
 
You could import a blank record 457230 and the auto numbering will reset to the next number.
For your information Auto numbering for records is not the best practice ,there are a number of threads in this forum of how you can achieve this with out auto numbering , something for the future maybe
Regards.
 
Thank you!!! I've had issues w/ auto numbering . . . I "inherited" this database so I'm tweaking out the details . . . thank you!
 
You are more than welcome. Did it solve your current problem ?
 

Users who are viewing this thread

Back
Top Bottom