Deleting of a record

[JEK]

When I delete a record I notice the auto record ID number is not used again,
is this a normal function of Access?

If I do a query on all records it will show that I am missing a record if I
deleted one, this may confuse me not realizing I deleted that record, is
there a way to identify that a record or records were deleted?

 

[Jeff C]

The auto ID is only a unique identifier. If you need to keep track of two
sets of records, say active and inactive then indicate a record inactive
rather than delete it altogether, possibly with a yes/no check box.

 

[Arvin Meyer [MVP]]

This is the normal behavior. Autonumbers must be unique and therefore can
never be reused. To be able to see deleted records, do not actually delete
them. Instead use a Yes/No field to mark them as deleted, and a query to
show only non-deleted records (or visa-versa) in your forms and reports.