Escape key - another question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When entering data in a new record (with autonumber key) then hitting escape
- this causes the autonumber to skip a number. Is this expected behaviour?
Thanks.
 
mscertified said:
When entering data in a new record (with autonumber key) then hitting
escape - this causes the autonumber to skip a number. Is this
expected behaviour? Thanks.
Click to expand...

Yep. Lots of normal activities produce gaps in an AutoNumber sequence. For
example, if you run an update query and cancel it at the prompt "You are about
to insert 5000 records..." then all 5000 of those AutoNumber positions are used
up.

AutoNumbers should be used when your ONLY concern is that the value be unique.
If you care about the value in any other way then don't use an AutoNumber.
 
Back
Top