AutoNumber not creating new numbers

G

Guest

I have an ID field in a table set to AutoNumber data type, and it's the
primary key (Indexed: Yes, no duplicates). When I create a new record,
Access re-uses an ID number that already exists in the table for that ID
field, and of course I get the message that a conflict exists in the index,
primary key, etc.

Any ideas where to start looking for the issue here? It's Access 2007. Is
this a new "feature" of 2007 -- where AutoNumber uses a number that is
already in use in the table? It is very strange.

Steve
 
A

Allen Browne

Steve, here's an explanation of some of the causes for this problem:
Fixing AutoNumbers when Access assigns negatives or duplicates
at:
http://allenbrowne.com/ser-40.html

As Norman pointed out a compact/repair sometimes fixes this problem. You can
use the code in the article above to fix other cases.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

AutoNumber Error 8
Autonumber suddenly reverts to earlier numbers 2
Autonumber trying to create duplicates 3
Autonumber Drastic Increase 4
Autonumber 7
How can I Manually Change Access Primary Key ID Fields ? 2
Autonumber Macro 3
Access Indeterminate relationship in many-to-many table (Windows 10, Access 2016) 5

Top