V
Van T. Dinh
Without seeing your database, my guess is that the
original developer used some sort of custom number
sequence for the (Primary?) Key for the Record but didn't
take into account the multi-user environment.
It is likely that when the other user starts creating a
new Record, a number from the custom number sequence (not
Access AutoNumber) is allocated according to existing
Records in the Table but no Record is actually created
with this number. When you jump in with your Macro, the
same process will be repeated with the same initial
conditions (since the other user hasn't actually added the
new Record into the Table) and you get allocated with the
same number. Since your Macro will be a lot faster, your
new Record will be saved. However, the other user will
have problems saving his/her new Record with the same
number.
You will need to get the original developer (or at least
someone who knows Access) to check it out. Hopefully, you
have the MDB file rather than the MDE file as the
canonical Text component of the code has been removed from
the database and you cannot modify the design of the MDE
file.
HTH
Van T. Dinh
MVP (Access)
original developer used some sort of custom number
sequence for the (Primary?) Key for the Record but didn't
take into account the multi-user environment.
It is likely that when the other user starts creating a
new Record, a number from the custom number sequence (not
Access AutoNumber) is allocated according to existing
Records in the Table but no Record is actually created
with this number. When you jump in with your Macro, the
same process will be repeated with the same initial
conditions (since the other user hasn't actually added the
new Record into the Table) and you get allocated with the
same number. Since your Macro will be a lot faster, your
new Record will be saved. However, the other user will
have problems saving his/her new Record with the same
number.
You will need to get the original developer (or at least
someone who knows Access) to check it out. Hopefully, you
have the MDB file rather than the MDE file as the
canonical Text component of the code has been removed from
the database and you cannot modify the design of the MDE
file.
HTH
Van T. Dinh
MVP (Access)