Auto Number in table

D

Deb

Hi all..

For some reason my auto number fieild in my client table
is reusing numbers. I cant enter any new clients becuase
it says it is causing a duplicate number....i cant have
the autonumber be duplicated becuase it is the primary
key and the identifier of each client, so it makes sense
that it wont let me save a record, but why would the auto
number field automatically be duplicating numbers, and
how can I fix it?

--Deb
 
A

Allen Browne

Yes, there was a bug in JET that was fixed a couple of service packs ago.

Copy the code from this article:
Fixing AutoNumbers when Access assigns negatives or duplicates
at:
http://members.iinet.net.au/~allenbrowne/ser-40.html
It checks through all your tables, locates the column with the AutoIncrement
property, reads the highest number used so far, and resets the Seed if
necessary.

To prevent the problem recurring, go to http://support.microsoft.com, the
Downloads section, and get SP8 for JET 4.
 

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

Auto-Numbering in a Table in MS Word 1
Autonum Problems 1
Auto number in an existing table 4
Data Entry Form and Auto Number ID 2
Auto Numbers 3
auto number in query 1
Auto populating fields from another table 3
Auto Number ID Field 4

Top