autonumber field

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
 
D

Douglas J. Steele

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.
 
Top