469,946 Members | 1,814 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,946 developers. It's quick & easy.

problem with autonumber-field in Access

I have a problem with a database of concerts, where I recently tried to
change the existing database with some new rows/categories and some new
names on a few of the existing ones. I have an id field that is
"autonumber", and this has become my problem. The original database had
listed 54 concerts, with unique ID's. Now, the ID autonumber section has
started to count from 1 again, and I can't register anything new in the
database because the ID won't be unique anymore.
How can I fix this? I've put a lot of work into this database, and I
really don't want to register all of it over again!

Thanks in advance!

Knut B. from Norway
Nov 13 '05 #1
1 1586
The duplicate autonumbers bug was fixed in one of the JET service packs. To
prevent it recurring, go to http://support.microsoft.com, the Downloads
section, and get the JET 4 Service Pack 8.

To fix the problem with the existing data, see:
Fixing AutoNumbers when Access assigns negatives or duplicates
at:
http://members.iinet.net.au/~allenbrowne/ser-40.html
The utility code resets the Seed of the AutoNumber to the correct value for
all affected tables.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Knut B. " <fr******@hotmail.com> wrote in message
news:1p******************@news2.e.nsc.no...
I have a problem with a database of concerts, where I recently tried to
change the existing database with some new rows/categories and some new
names on a few of the existing ones. I have an id field that is
"autonumber", and this has become my problem. The original database had
listed 54 concerts, with unique ID's. Now, the ID autonumber section has
started to count from 1 again, and I can't register anything new in the
database because the ID won't be unique anymore.
How can I fix this? I've put a lot of work into this database, and I
really don't want to register all of it over again!

Thanks in advance!

Knut B. from Norway

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Mary Walker | last post: by
2 posts views Thread by Charles Robinson III | last post: by
1 post views Thread by Patrick Fleury | last post: by
35 posts views Thread by Traci | last post: by
4 posts views Thread by Vladislav | last post: by
4 posts views Thread by Bradley Burton | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.