Primary key in MS Access 2013

MS Access auto-numbers each record and by default uses the record number as the primary key.

If a record is deleted does (a) the auto-numbering take over to fill in the gap in the numbering or (b) does it leave the gap unfilled?

I need a primary key system that supports option (b).

Help please.
Who is Participating?
It will leave the gap unfilled
Gordon_AtherleyAuthor Commented:

Just exactly the information I needed, thank you!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.