AutoNumber field producing wrong numbers

  • Thread starter Thread starter Amer
  • Start date Start date
A

Amer

I am entering data into a table which has an AutoNumber field as Key. After
record number 176 the field is generating a new sequence starting by 1299356.

I wonder what the reason could be and how to solve this issue?

Thanks.
 
Delete any records with strange values.

Then try a compact/repair. In Access 2007, that's:
Office Button | Manage
In older versions, it's:
Tools | Database Utilities

If that doesn't work, you can use the code from this article to reset the
Seed of the AutoNumber:
Fixing AutoNumbers when Access assigns negatives or duplicates
at:
http://allenbrowne.com/ser-40.html
 
Unfortunately using Compact/Repair did not solve the issue.

I'm afraid that using your second suggestion is not required because I am
not having negative or duplicates. It's only moving from 3 digits to 7 digits
as explained earlier.

Hopefully you could help with this.

Thank you.
 
Resetting the Seed will fix the problem if it is set 'badly', regardless of
what 'badly' means for you.

Be sure to do this in the database where the table resides (not in one that
just has a linked table.)
 
Hey did you know that when you clear your history
and set up links into ie it takes you to the order page
but guess what the form dosen't go forward! my pages
are freezing i found a soultion this morning. all you have to do is call
their helpline.
 
Back
Top