missing records

[lynn atkinson]

Not sure if this is the correct place to post this, but here goes.
I have a database in which one of the tables is 'vacancy and recruitment'.
The table is updated via a form which is based on a query containing 3
tables. We are getting a few instances when the administrator creates and
fills in a new record in the form, but when she later tries to go back in to
the record, it doesnt exist. It must have been created in the first place,
however, as the next new record does take the next available autonumber for
the reference. When I go to check the vacancy and recruitment table, there is
no sign of the 'missing' records, but the subsequent numbers are there.
For example the sequence goes record 86, 89,90,92 with records numbered
87,88,91 missing.
The user does not have priveliges to delete records, so it cant be that.
Does this sound like an Access problem? Could it be a corruption problem?
Could it be a network problem ie dropping connection to server at a critical
point?

If anyone has any ideas on what may be happening, then please let me know.

 

[Allen Browne]

Lynn, there is a very nasty bug in Access, where it silently loses what you
enter if you close the form with the Close action (macro) of method (VBA
code.) If you close the form with the button at the top right of the form's
title bar, you are warned if the record cannot be saved, but not if you use
the close action/method. More info:
http://allenbrowne.com/bug-01.html

Note that Access assigns the autonumber at the time when you begin adding
the record. If the record is not then added (either because the user undid
the entry, or because it did not save due to a required field missing, a
validation rule not met, etc), this autonumber is not reassigned, so that
fits what you observed.