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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using a sequence number 2
Primary Key Autonumber - Is it the best choice for discrete ID num 11
Escape key when entering new record 2
Combine number in a Table field 1
getting an autonumber field to go beyond 3999 5
Creating a key consisting of two columns 1
Autonumber 2
Autonumber 4

Back
Top