ISO140001 said:
As an Access novice I have created a table to store information about
corrective actions performed as a result of internal ISO audits. Each
corrective action is a separate record and is numbered using an auto number
field. One of the auto number records was inadvertently deleted (by me or
someone else). I would like to replace this deleted record with its
initial number (70) if possible. It seems that an append query may be the
answer but I have been unsuccessful to date in replacing the deleted
record. Am I wasting my time with the append query or should I keep
trying. Any suggestions or short cuts to make this work?
Normally an append query that specifies a value for the AutoNumber column
will accept that value instead of auto-assigning one as long as the value
is not already in the table. I know for sure that this works for values
that have NEVER existed in the table. I am not so sure about values that
were once in the table and subsequently deleted.
<Standard AutoNumber admonishment>
Whenever you *care* about the value of a number in any way other than
uniqueness, DON'T use an AutoNumber. They have numerous ways under normal
usage that will result in gaps in the sequence. Their only legitimate
purpose is to provide a unique record identifier.
If you want a number that increments without gaps then assign your own
number in an event of the form used to do insertions.
