G
Guest
Why is my database suddenly duplication already used autonumbers? I went to
add some new records to the main table, and discovered that this is
happening. I checked the design; the Primary Key is set at the StudentID
field, the Field Size is "Long Integer", the New Values is "Increment", the
Format is "0000" (four zeroes), the Indexed is set at "Yes (No Duplicates)",
yet this is what I am getting.
I did an Ascending Sort of the StudentID field to insure that the new
records should be at 5883, and I'm getting 5712. However, when I go to close
the table with the "new" record, I get and error message telling me that.... OK<<; when I click on the OK button, I then get a pop-up message telling
me that if the table closes, the data may be lost ... do I want to close it
anyway?<< So knowing I have a copy, I click on YES.
Then I try opening it back up to see what happens if I try again to add a
new record, and the same thing happens, but this next time I try to add the
new record, the StudentID autonumber is increased by 1!
So I could just do this about 150 times to get the autonumber back to where
it should be, but it seems to me something needs fixing, and there's no one
here to do it (you know, the ol' 'no budget' story). In my searching around
this web-site, I came across a message somewhere that said I need SP 8 for
Jet 4, but when I went to download it, there was a message saying that I need
intermediate macro and coding skills, and I DO know enough to know that I do
not have those skills (I barely know what a macro is, and isn't coding the
same thing as programming?)
So while I'm waiting for notification of any replies, I will be adding and
letting go these "fake duplicate records".... See you in the wonderful land
of data entry....
In Peace,
add some new records to the main table, and discovered that this is
happening. I checked the design; the Primary Key is set at the StudentID
field, the Field Size is "Long Integer", the New Values is "Increment", the
Format is "0000" (four zeroes), the Indexed is set at "Yes (No Duplicates)",
yet this is what I am getting.
I did an Ascending Sort of the StudentID field to insure that the new
records should be at 5883, and I'm getting 5712. However, when I go to close
the table with the "new" record, I get and error message telling me that.... OK<<; when I click on the OK button, I then get a pop-up message telling
me that if the table closes, the data may be lost ... do I want to close it
anyway?<< So knowing I have a copy, I click on YES.
Then I try opening it back up to see what happens if I try again to add a
new record, and the same thing happens, but this next time I try to add the
new record, the StudentID autonumber is increased by 1!
So I could just do this about 150 times to get the autonumber back to where
it should be, but it seems to me something needs fixing, and there's no one
here to do it (you know, the ol' 'no budget' story). In my searching around
this web-site, I came across a message somewhere that said I need SP 8 for
Jet 4, but when I went to download it, there was a message saying that I need
intermediate macro and coding skills, and I DO know enough to know that I do
not have those skills (I barely know what a macro is, and isn't coding the
same thing as programming?)
So while I'm waiting for notification of any replies, I will be adding and
letting go these "fake duplicate records".... See you in the wonderful land
of data entry....
In Peace,