Avoid duplicate indexes in Access

[kbfleming]

I am running into a problem that seems to have had no precipitating event
that caused it. One day it worked the next it didn't. I am working with
Access 2000 and have created a simple input form that contains two sub forms.
One of the subforms is linked to a table that for no apparent reason has
started duplicating index numbers from the beginning. In one shot I entered
35 clean records. The next time I opened the database to enter new records
the table started over with record "0" which it accepted and then counted up
1, 2, 3 etc. However, after record "0" (I don't know where that came from
since my key is an Auto number) it rejected any new entries because of course
I already have a record 1, and2, and so on. I am throughly confused how this
could happen. My other tables are working fine.

 

[John Vinson]

I am running into a problem that seems to have had no precipitating event
that caused it. One day it worked the next it didn't. I am working with
Access 2000 and have created a simple input form that contains two sub forms.
One of the subforms is linked to a table that for no apparent reason has
started duplicating index numbers from the beginning. In one shot I entered
35 clean records. The next time I opened the database to enter new records
the table started over with record "0" which it accepted and then counted up
1, 2, 3 etc. However, after record "0" (I don't know where that came from
since my key is an Auto number) it rejected any new entries because of course
I already have a record 1, and2, and so on. I am throughly confused how this
could happen. My other tables are working fine.

Well... first off... an "Autonumber" is not an "Index", and an Index
is not an Autonumber. They're totally different concepts.

There is a bug in some versions of Access as released which causes
autonumbers to duplicate. Go to the Microsoft Office Update site and
apply all the service patches to your machine, especially the JET
service packs. See

http://support.microsoft.com/default.aspx?scid=kb;en-us;291162

for details.

John W. Vinson[MVP]

 

[kbfleming]

Thanks, I did eventually find that very link after much searching. Also,
thanks for the clarification on indexes and such, although I know the
difference I was being lazy in my email (the result of frustration and a
headache).

Thanks again.