By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,961 Members | 1,320 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,961 IT Pros & Developers. It's quick & easy.

problem with autonumber-field in Access

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.