Access Form - New ID incorrect when trying to enter a new record

Hi

In my Access tabular form which is  bound to a table called "Parts" when I go to enter
a new record where it says "(New)" the ID that is generated is not a new ID but rather an existing older ID.
Why would this happen?

1
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
 
Dale FyeCommented:
additionally, the autonumber functionality can break (rarely) and start to generate duplicate numbers.  

Check out this article on Allen Browne's website.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
An autonumber ID is not guaranteed to be sequential.  

  The value can be reset:

https://support.microsoft.com/en-us/help/812718/how-to-reset-an-autonumber-field-value-in-access

Jim.
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Hi. Thank you both. I have been using Access since 2005 and never seen this issue, I wonder if the database being in Dropbox may have been the issue
0
 
Dale FyeCommented:
"I wonder if the database being in Dropbox may have been the issue"

Yes, I would not consider using Dropbox as the storage location for a BE for my database application.

Dale
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.