autonumber field

  • Thread starter Thread starter Steve Marcum
  • Start date Start date
S

Steve Marcum

I have a small table with an autonumber field to track
entered records, if my laptop goes to standby while I
have my access program open,when I come out of standby
the next autonumber is missing. Any help

Steve
 
Autonumbers are not guaranteed to be contiguous. If that's a necessity, you
might want to reconsider using them.

For all intent and purposes, Autonumbers exist for the sole purpose of
providing an (almost guaranteed) unique value that can be used for a primary
key. The presence of gaps does not impact this use. Seldom, if ever, should
their value be shown to the user.
 
If you think that is bad, just wait and see what other things it can do
with autonumbers. They are not designed to stay in order, only to be
unique.

If you do a repair and compact of that database, it may find some of
those missing numbers and may use them from time to time. Good Luck
 
Back
Top